topic Re: Code is not working as intended in SAS Programming

Code is not working as intended

atinytale — Wed, 26 Jul 2023 01:53:53 GMT

%let x= 2020Q1;

%let y= 0;

%macro xyz();

%if &y =0 %then

%let abc = %sysfunc(intnx(qtr, %sysfunc(inputn(&x, yyq6.)),0,b),yyq6.);

%mend;

%xyz;

when I execute the above code, the macro abc is not resolved. Can anyone please help?

thanks in advance.

Re: Code is not working as intended

whymath — Wed, 26 Jul 2023 02:22:38 GMT

If you want to use macro variable abc outside of macro, you need to make it a global macro variable:

%let x= 2020Q1;
%let y= 0;

%macro xyz();
%global abc;
%if &y =0 %then 
%let abc = %sysfunc(intnx(qtr, %sysfunc(inputn(&x, yyq6.)),0,b),yyq6.);
%mend;

%xyz;
%put &=abc;

ABC=2020Q1

And you may want to know Scopes of Macro Variables