Trying to build multiple if conditions with macro variables

[JenniferLee]

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).

<The original code with success>

data want;

  set table;

    where condition;

       if condition1 then do;

             &macro1.

      end;

      else do;

            &macro2.

      end;

run;

<The edited code with failure>

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.

[Kurt_Bremser · Accepted solution]

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;

[JenniferLee]

It works, Thank you so much!