topic create a macro variable YYYYMM from MACRO varaibles YYYY and MM in SAS Programming

create a macro variable YYYYMM from MACRO varaibles YYYY and MM

Ronein — Thu, 21 Oct 2021 05:08:52 GMT

Hello

I want to create a macro variable YYYYMM that is created by concatenation of MACRO varaibles YYYY and MM.

When MM=09 and YYYY=2021 I expect to get 202109 but I get 20219 in way2 and way3.

Why way2 and way3 are not working as I desired?

What is the solution to adjust way2 and way3 to the desired outcome 202109?

%let MM=09;
%put &MM; /*09*/
%let YYYY=2021;
%put &YYYY; /*2021*/
/**Way1**/
Data _null_;
sas_date=MDY(&MM.,1,&YYYY.);
YYYYMM=put(sas_date,YYMMn6.);
call symput('YYYYMM',YYYYMM);
Run;
%put &YYYYMM.;
/**Way2-no good because get 20219**/
%let YYYYMM= %sysfunc(catS(&YYYY.,&MM.));
%put &YYYYMM.;
/**Way3-no good because get 20219**/
data _null_;
call symput('YYYYMM2',catS(&YYYY.,&MM.));
run;
%put &YYYYMM.;

Re: create a macro variable YYYYMM from MACRO varaibles YYYY and MM

japelin — Thu, 21 Oct 2021 05:06:46 GMT

try this

call symput('YYYYMM',catS("&YYYY.","&MM."));

%let YYYYMM= %sysfunc(catS(&YYYY.&MM.));

Re: create a macro variable YYYYMM from MACRO varaibles YYYY and MM

andreas_lds — Thu, 21 Oct 2021 05:05:29 GMT

Working as expectable: The arguments of cats are treated as numerics, so leading zeros are stripped. You should drop %sysfunc from your syntax and just use:

%let yyyymm = &yyyy.&mm.;

Re: create a macro variable YYYYMM from MACRO varaibles YYYY and MM

Ronein — Thu, 21 Oct 2021 05:36:08 GMT

What is the reason for difference between these 2 ways?


%let YYYY=2021;
%let MM=09;
/***Way A***/
data _null_;
call symput('YYYYMM',catS("&YYYY.","&MM."));
run;
%put &YYYYMM.;/*Get 202109*/


/***Way B***/
%let YYYYMM= %sysfunc(catS("&YYYY.","&MM."));
%put &YYYYMM.;/*Get "2021""09"*/

Re: create a macro variable YYYYMM from MACRO varaibles YYYY and MM

andreas_lds — Thu, 21 Oct 2021 05:43:01 GMT

@Ronein wrote:

What is the reason for difference between these 2 ways?


%let YYYY=2021;
%let MM=09;
/***Way A***/
data _null_;
call symput('YYYYMM',catS("&YYYY.","&MM."));
run;
%put &YYYYMM.;/*Get 202109*/


/***Way B***/
%let YYYYMM= %sysfunc(catS("&YYYY.","&MM."));
%put &YYYYMM.;/*Get "2021""09"*/

Because quotes are not necessary in the macro-world of sas, they are not treated as chars identifying a string, but as content of the variable.

Re: create a macro variable YYYYMM from MACRO varaibles YYYY and MM

Kurt_Bremser — Thu, 21 Oct 2021 07:12:47 GMT

You overcomplicate things by a mile. In macro language, concatenation of texts is done in a simple %LET:

%let yyyymm = &yyyy.&mm.;

A data step is only needed if you need to set macro variables from dataset values, or want to simplify calculations and avoid %SYSFUNC-avalanches.

Re: create a macro variable YYYYMM from MACRO varaibles YYYY and MM

Kurt_Bremser — Thu, 21 Oct 2021 07:15:36 GMT

The macro processor is a text processor and does not need quotes to identify text as such. Quotes are part of text for the macro processor.

Write the above down repeatedly until you run out of paper or have finally internalized it.

Re: create a macro variable YYYYMM from MACRO varaibles YYYY and MM

PaigeMiller — Thu, 21 Oct 2021 11:33:59 GMT

If it was up to me, I would change the correct answer to the one provided by @andreas_lds , as %SYSFUNC(CATS()) is not needed to concatenate macro variables (which is a good lesson to learn).

Re: create a macro variable YYYYMM from MACRO varaibles YYYY and MM

Tom — Thu, 21 Oct 2021 13:42:02 GMT

The %SYSFUNC(CATS()) is doing nothing in that statement.

Once the macro variables are resolved you already have the string.

%let YYYYMM= &YYYY.&MM.;

Or in data step

yyyymm_var = "&yyyy.&mm.";

Re: create a macro variable YYYYMM from MACRO varaibles YYYY and MM

PaigeMiller — Thu, 21 Oct 2021 14:34:55 GMT

I am curious as to why a problem would begin with have macro variables &YYYY and &MM, as opposed to starting with an actual date.

If you start with an actual date, you don't have to pull out the year into &YYYY and then pull out the month into &MM and then combine them. If you start with a date, then creating a macro variable &YYYYMM is trivial using formats.

It seems as if the problem starts at the wrong point, and if you just go back a little further to start with a date, there is no need to do the work to separate the year from the month and then re-combine them.