topic Re: date formats in SAS Programming

date formats

SAS_INFO — Tue, 04 Apr 2017 00:34:07 GMT

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 — Tue, 04 Apr 2017 00:53:42 GMT

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 — Tue, 04 Apr 2017 02:34:05 GMT

Or in one shot

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

%put &rdate;

2017Apr