topic Re: Trying to build multiple if conditions with macro variables in SAS Programming

Trying to build multiple if conditions with macro variables

JenniferLee — Thu, 24 Aug 2023 07:47:11 GMT

Here is the code I'm trying to execute but keep hitting error.

&FLG is a variable imported from a different table

&macro1 and &macro2 are variables I'm trying to store values based on the condition rules (condition1-4).

data want;

set table;

where condition;

if condition1 then do;

&macro1.

end;

else do;

&macro2.

end;

run;

data want;

set table;

where condition;

if &FLG. eq Y then do;

if condition1 then &macro1.;

if condition2 then &macro2.;

end;

if &FLG. eq N then do;

if condition3 then &macro1.;

if condition4 then &macro2.;

end;

run;

It would be a great help if you can advise which part I'm missing and how to fix the code to run successfully.

Re: Trying to build multiple if conditions with macro variables

Kurt_Bremser — Thu, 24 Aug 2023 07:08:00 GMT

In data step code, you compare variables or values. Character values have to be enclosed in quotes. So, when your %flg macro returns either a Y or N, the data step code has to be

 if "%FLG" eq "Y" then do;

Re: Trying to build multiple if conditions with macro variables

JenniferLee — Thu, 24 Aug 2023 08:43:01 GMT

It works, Thank you so much!