DATA Step, Macro, Functions and more

date formats

Accepted Solution Solved
Reply
Contributor
Posts: 60
Accepted Solution

date formats

 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.


Accepted Solutions
Solution
‎04-03-2017 09:34 PM
Trusted Advisor
Posts: 1,128

Re: date formats

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;
Thanks,
Jag

View solution in original post


All Replies
Solution
‎04-03-2017 09:34 PM
Trusted Advisor
Posts: 1,128

Re: date formats

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;
Thanks,
Jag
Super User
Posts: 17,731

Re: date formats

Or in one shot

 

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

%put &rdate;

 

2017Apr

 

 

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 108 views
  • 2 likes
  • 3 in conversation