date formats

[SAS_INFO]

 Hi All,

I need to crete a datset each month  as per the following  naming convention.

AB002_2017APR

for this wat is have used is AB002_&sysyear&sysmon

which resulets as AB002_201704, but what i need is AB002_2017APR.

Is there any format i couls use to get the desired result.

[Jagadishkatam · Accepted solution]

Please try to use the %substr function to pull the mon in letters

%let sysmon= %substr(&sysdate,3,3);
%let sysyear= %sysfunc(year("&sysdate"d));

%put &sysmon &sysyear;

[Reeza]

Or in one shot

%let rdate= %sysfunc(today(), yymon7.);

%put &rdate;

2017Apr