topic Re: datetime format in SAS Procedures

datetime format

Tal — Mon, 22 Sep 2014 18:58:26 GMT

hi guys,

Can anyone please tell me what i am doing wrong here

data test;

date='02oct2014'd;

format date datetime18.;

run;

the date in the output is 1/1/1960 5:33:18 AM

Thanks

Re: datetime format

Tom — Mon, 22 Sep 2014 19:00:59 GMT

You are trying to write a date (number of days) using a datetime format. So it is interpreting the number of days as the number of seconds.

Re: datetime format

stat_sas — Mon, 22 Sep 2014 19:08:07 GMT

In order to get it in datetime format, try something like this

data test;

date='02oct2014'd;

new_date=date*86400;

format date date9. new_date datetime18.;

run;

Re: datetime format

Tal — Mon, 22 Sep 2014 23:08:46 GMT

thank you both

so i actually used new_date=dhms(date,00,00,00) and then applied the format datetime.

Re: datetime format

Tom — Tue, 23 Sep 2014 01:12:26 GMT

You could also just write a datetime literal instead of a date literal.

datetime='02oct2014:00:00'dt;

Re: datetime format

Tal — Tue, 23 Sep 2014 01:18:58 GMT

I know but the thing is this date variable is actually a macro var from another SAS code which resolves to 02oct2014 so I had to use the "&date"d in the dhms function

Re: datetime format

SASKiwi — Tue, 23 Sep 2014 05:21:48 GMT

Using Tom's method you could specify "&date.:00:00:00"dt to resolve your SAS date as a datetime.