Get month value in sas macro

[Liangck]

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 · Accepted solution]

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]

%let sdate=20061212;

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

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

%put _user_;

[Liangck]

Linus Randy Dai:

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

          thanks, apperciate alot.

Regards

Liangck