Hey folks,
I know one day the light bulb will go off, but I still struggle with SAS dates. I want a 2 digit month variable called 'emo' that I can pass to other data steps. It resolves to '2' and I want '02'. Here's my code: Mucho thanks!
data _null_;
sdate = '01feb2015'd;
edate = '28feb2015'd;
emo = month(edate);
eyr = year(edate);
call symput ('sdate', "'"||trim(left(put(sdate, date9.)))||"'");
call symput ('edate', "'"||trim(left(put(edate, date9.)))||"'");
call symput ('emo',emo);
call symput ('eyr',eyr);
put emo = 2.;
fim_tu_wo = cats(of eyr,emo);
call symput ('fim_tu_wo', trim(left(put(fim_tu_wo,$7.))));
put _all_;
run;
If your emo variable is numeric then use Z2. format;
But if you are looking to create 201502
try call symput (fim_tu_wo, put(edate,yymmn6.));
If your emo variable is numeric then use Z2. format;
But if you are looking to create 201502
try call symput (fim_tu_wo, put(edate,yymmn6.));
Thank you sir!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.