topic Re: How resolve macro variable in SAS Programming

How resolve macro variable

thanikondharish — Mon, 19 Aug 2019 06:39:21 GMT

%let I=1;
%let state1=ap;
%let ap1=India;
%let India1=Asia;
/*First*/
I want to resolve ap1 macro variable I wrote like below.
Data ex1;
Name="&&&state&I." ;
Run;

/*Second*/
I want to resolve India1 macro variable I wrote like below.
Data ex2;
Name="&&&&&&&state&I.";
Run;
But above 2 codes not working the macro variables are not resolving

Re: How resolve macro variable

PeterClemmensen — Mon, 19 Aug 2019 06:49:00 GMT

Just to be clear, what do you want the value of Name to be in the two code snippets?

Re: How resolve macro variable

thanikondharish — Mon, 19 Aug 2019 07:03:16 GMT

First: name=India
Second name=asia

Re: How resolve macro variable

PeterClemmensen — Mon, 19 Aug 2019 07:17:39 GMT

Are the macro variables fixed or can I change them a bit? Seems easier not having the 1 in all of them

Re: How resolve macro variable

Jagadishkatam — Mon, 19 Aug 2019 08:40:53 GMT

Please try the below code


Data ex1;
Name="&&&state&I.&&i" ;
Run;

Re: How resolve macro variable

Shmuel — Mon, 19 Aug 2019 08:53:29 GMT

Change your code into:

%let I=1;
%let state1=ap;
%let ap1=India;
%let India1=Asia;
/*First  - I want to resolve ap1 macro variable I wrote like below. */
Data ex1;
Name="&&&state&I&&I." ; 
Run;

/*Second*/
I want to resolve India1 macro variable I wrote like below.
Data ex2;
Name="&&&&&&state&I&&i.";
Run;

Remember - sas resolves macros step by step. Each pair of && become a single &, thus:

1) &&&&&&state&I&&i

2) &&&state1&i

3) &&ap1

4) India