Solved: Convert date to a literal

mauley · Posted 01-21-2019 06:19 AM

Hi,

I have a date value 21549 (31Dec2018) and I would like to convert this to a number that is 20181231

Thank You !

PeterClemmensen · Posted 01-21-2019 06:27 AM

Do like this

data test;
   date=21549;
   num=input(put(date, yymmddn8.), 8.);
   format date date9.;
run;

PeterClemmensen · Posted 01-21-2019 06:27 AM

Do like this

data test;
   date=21549;
   num=input(put(date, yymmddn8.), 8.);
   format date date9.;
run;

mauley · Posted 01-21-2019 06:31 AM

HI Draycut,

Thank You!

Convert date to a literal