Suppose I import a bunch of SAS dates into R. How well does that work?

Not very. First is the import itself. If you use read.csv, R will try to import the datetime field as factors, which creates a big ol mess. Let’s fix that first. When you use read.csv, remember to include this phrase:

stringAsFactor=FALSE

in the read.csv function as a parameter. That will import the SAS datetime field as a string. OK, now lets do our conversion:

datetime.field=strptime(SAS_DATE_TIME, “%d%b%Y:%H:%M:%S.%s”)

And you’re done. Problem solved.

Leave a Reply

Your email address will not be published. Required fields are marked *