Macro %IF %THEN %DO %PUT %STR in DATA WHERE step

[feyzi]

This is my first post so apologies for any faux pas...

I want to create a dataset using a DATA step in a macro. In the dataset I use a WHERE step, which I want to be dependent on the macro variable (TABLE).

So I've written the following but it doesn't work. It just takes it as "...WHERE FINANCIAL_ID IN (5);..."

I've tried many different things with this but can't get it to work... Any ideas would be most welcome.

%MACRO LOSSES(TABLE);

DATA INS_RSK_&TABLE;

  SET INS_RSK_S;

  WHERE FINANCIAL_ID IN (5, %IF &TABLE="LN" %THEN %DO; %PUT %STR(,9); %END;);

RUN;

%MEND;

Thank you very much.

[Fraktalnisse · Accepted solution]

Maybe this example can help you:

%macro test(var);
data table;
   set sashelp.class;
   where age in (12 %if &var=fourteen %then ,14 ;  );
run;
%mend;

%test(fourteen)
%test(notfourteen)

[feyzi]

Thank you very much!