topic I am learning the macros,please solve this if you can in SAS Programming

I am learning the macros,please solve this if you can

sahaji — Mon, 09 Dec 2013 16:31:36 GMT

from a given date for ex. 1st nov 2013

1. assign the date in yyyy_mm format to a macro variable

2.Assign the date in MMM_YY foramt to a macro variable

Re: I am learning the macros,please solve this if you can

PaigeMiller — Mon, 09 Dec 2013 16:45:53 GMT

Answer to #1: %let macrovar=2013_11;

Answer to #2: should be obvious from answer to #1

Re: I am learning the macros,please solve this if you can

Eshan — Mon, 09 Dec 2013 16:54:16 GMT

Here it is.

data temp;

dt = today();

call symput('dt1', catx('_', year(dt), put(month(dt),2.)));

call symput('dt2', catx('_', substr(put(dt,date9.),3,3), substr(put(dt,date9.),8,2)));

run;

%put &dt1= &dt2=;

Re: I am learning the macros,please solve this if you can

data_null__ — Mon, 09 Dec 2013 17:14:14 GMT

Maybe this is what you mean. Your question is somewhat vague.

18         %let given=%sysevalf('1nov2013'd);
19         
20         %let a = %sysfunc(putn(&given,yymon));
21         %let b = %sysfunc(putn(&given,monyy));
22         %put NOTE: &=a &=b;
NOTE: A=2013NOV B=NOV13

Re: I am learning the macros,please solve this if you can

sahaji — Mon, 09 Dec 2013 19:07:03 GMT

Thanks for your reply,it is helpful for me, giving correct result