topic Re: Convert numeric to datetime stamp in SAS Programming

Convert numeric to datetime stamp

PravinMishra — Mon, 03 Nov 2014 22:56:27 GMT

I have a date value

19370

19375

i would Like to convert it in

12JAN13:00:00:00

17JAN13:00:00:00

I am using below piece of code but it's not working

tranwrd(put(dhms(datepart(ldate),0,0,0),E8601DT19.),"T","");

Thanks

Re: Convert numeric to datetime stamp

Reeza — Mon, 03 Nov 2014 23:18:49 GMT

Your values are dates so you don't need the date part function. The format you want is a SAS format, datetime21 so you can apply that directly. The code below demonstrates this, time_want is the numeric version of the variable and time_want_char is the character version of the variable.

data have;

input time;

cards;

19370

19375

;

run;

data want;

set have;

time2=time;

time_want=dhms(time, 0, 0, 0);

time_want_char=put(time_want, datetime21.);

format time time_want datetime21. time2 date9.;

run;

Re: Convert numeric to datetime stamp

art297 — Mon, 03 Nov 2014 23:26:53 GMT

How about:?

data want;

set have;

ndt=tranwrd(put(dhms(ldate,0,0,0),E8601DT19.),"T","");

run;

Re: Convert numeric to datetime stamp

stat_sas — Mon, 03 Nov 2014 23:50:12 GMT

data have;

input time;

time_want=time*86400;

format time_want datetime.;

cards;

19370

19375

;