Hi.. I'm relatively new and I'm Trying to extract 60 months data from source tables which names as DATA_YYYYMM and created separate data tables.
I wrote the below macro for this.
%MACRO DO_YRMN;
%do YY = 2015 %to 2020;
%do MM = 01 %to 12;
DATA My_DATA_TABLE&YY.&MM
/**** my VAR*****/
SET SOURCE_TABLE&YY.&MM;
RUN;
%END;
%END;
%MEND DO_YRMN;
%DO_YRMN;
Macro runs fine. But the issue is zero is not used. So SAS created code as YYYYM only (20191) instead of YYYYMM(201901)
how about this code.
%do MM = 01 %to 12;
%if &MM<10 %then %let MM=0&MM.; /* Add this line */
how about this code.
%do MM = 01 %to 12;
%if &MM<10 %then %let MM=0&MM.; /* Add this line */
Or do this:
%do mm = 1 %to 12;
%let mm = %sysfunc(putn(&mm.,z2.));
Since you appear to be looping over months it is probably better to use actual dates instead.
%MACRO DO_YRMN;
%local start end offset yymm ;
%let start='01JAN2015'd ;
%let end='01DEC2020'd;
%do offset=0 %to %sysfunc(intck(month,&start,&end));
%let yymm = %sysfunc(intnx(month,&start,&offset),yymmn6.);
DATA My_DATA_TABLE&YYMM
/**** my VAR*****/
SET SOURCE_TABLE&YYMM;
RUN;
%end;
%MEND DO_YRMN;
%DO_YRMN;
Now you can use intervals that are not complete years.
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.