topic Re: converting sasdate macro variable to date9.? in SAS Programming

converting sasdate macro variable to date9.?

Lochen — Thu, 14 Sep 2017 23:21:11 GMT

Hi,

I have a macro variable _mydate in the sasdate format, is there anyway to convert it to data9. foramt?

For example,

%let _mydate = 20399;

I want it to be

&_mydate =07NOV2015

Thanks!

SASKiwi — Thu, 14 Sep 2017 23:28:47 GMT

%let _mydate = %sysfunc(putn(20399, date9.));

%put &_mydate;

Reeza — Fri, 15 Sep 2017 03:09:27 GMT

How are you creating the date, is there an option to create it formatted in the first place?

%let date = %sysfunc(today(), date9.);
%put &date.;

Lochen — Fri, 15 Sep 2017 03:19:55 GMT

It's the most recent date from a datset.