BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
MrTAL
Fluorite | Level 6

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)

1 ACCEPTED SOLUTION

Accepted Solutions
japelin
Rhodochrosite | Level 12

how about this code.

 

%do MM = 01 %to 12;
%if &MM<10 %then %let MM=0&MM.; /* Add this line */

View solution in original post

6 REPLIES 6
japelin
Rhodochrosite | Level 12

how about this code.

 

%do MM = 01 %to 12;
%if &MM<10 %then %let MM=0&MM.; /* Add this line */
MrTAL
Fluorite | Level 6
Thanks.. it worked..
MrTAL
Fluorite | Level 6
Thank you so much.. this works tooo.. both the solutions are working.. 🙂
Tom
Super User Tom
Super User

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.

MrTAL
Fluorite | Level 6
Wow.. that's great.. Thank you so much for the knowledge share.. 🙂

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 2138 views
  • 6 likes
  • 4 in conversation