topic Re: datetime format in SAS Programming

datetime format

arde — Tue, 11 Sep 2018 14:58:40 GMT

Hi,

is there a way to import a datetime format from a csv file as a date9 variable? For example:

data have;
input Date_Time_Partial;
informat Date_Time_Partial anydtdtm40. ;
format Date_Time_Partial DATE9. ;

datalines;
11SEP18:00:00:00
;
run;

When I run the program above, I get a result of *********

Is it possible to get the output of 11Sep2018 within this step?

novinosrin — Tue, 11 Sep 2018 15:05:29 GMT

data have;
input Date_Time_Partial;
informat Date_Time_Partial date7. ;
format Date_Time_Partial DATE9. ;
datalines;
11SEP18:00:00:00
;
run;

arde — Tue, 11 Sep 2018 16:04:34 GMT

thank you