topic Get month value in sas macro in SAS Procedures

Get month value in sas macro

Liangck — Thu, 29 Sep 2011 05:04:30 GMT

Hello all,

i am going to read a file name thats like B11_20110926_DeliverStatus.csv

i am able to collect the date by substring the file using the following code:

%substr(B11_20110926_DeliverStatus.csv,4,8);

but i am unable to get the MONTH of the substring's file.

is that possible to convert the 20110926 to a sas datetime format?

i try to get the date by using following code.

is that still anyway to do so?

Regards:

Liangck

LinusH — Thu, 29 Sep 2011 08:15:41 GMT

Isn't %substr(B11_20110926_DeliverStatus.csv,9,2); working for you?

You can use the macro function %sysfunc, whic let's you use (almost) any SAS function within a macro context:

%let sasdate = %sysfunc(inputn(%substr(B11_20110926_DeliverStatus.csv,5,8),yymmdd8.));

/Linus

RD2 — Thu, 29 Sep 2011 08:42:57 GMT

%let sdate=20061212;

%let ndate=%sysfunc(inputn(&sdate,yymmdd10.));

%let nmonth=%sysfunc(month(&ndate));

%put _user_;

Liangck — Thu, 29 Sep 2011 09:39:02 GMT

Linus Randy Dai:

Thank you both, i tried both answer and i got got the result perfectly.

thanks, apperciate alot.

Regards

Liangck