topic importing sas datetime in SAS Programming

importing sas datetime

ari — Wed, 15 Mar 2017 12:30:35 GMT

I am trying to import a csv file with datetime variable in the form

2011-02-02T15:22

But when the data is imported, only date remains like this

2011-02-02

Any help to import the datetime variable correctly?

Thanks,

Re: importing sas datetime

Kurt_Bremser — Wed, 15 Mar 2017 12:37:17 GMT

Use the e8601dt informat, as in

data test;
string = "2011-02-02T15:22";
dtval = input(string,e8601dt19.);
format dtval datetime19.;
put dtval=;
run;

You can use that informat directly in the input statement.

Re: importing sas datetime

RW9 — Wed, 15 Mar 2017 12:40:27 GMT

Post the import code (into a {i}) so we can see how you are importing it.

Re: importing sas datetime

ari — Wed, 15 Mar 2017 13:21:19 GMT

proc import datafile='test.csv' out=data dbms=csv replace;
getnames=yes;
datarow = 2;
run;

Re: importing sas datetime

Kurt_Bremser — Wed, 15 Mar 2017 13:24:26 GMT

Copy the data step from the log (proc import writes the data step it creates to the log) and adapt the informat for the column in question.

Then re-run the data step.

Re: importing sas datetime

RW9 — Wed, 15 Mar 2017 13:34:54 GMT

Yes, as @Kurt_Bremser has stated, use a datastep import and set the columns yourself. Proc import is a guessing procedure - i.e. it is guessing what your data is. Never a good idea.

Re: importing sas datetime

ari — Wed, 15 Mar 2017 20:38:52 GMT

@Kurt_Bremser

Thanks. it worked.