topic Re: Macro %IF %THEN %DO %PUT %STR in DATA WHERE step in SAS Programming

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

feyzi — Tue, 05 Mar 2013 10:30:11 GMT

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.

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

Fraktalnisse — Tue, 05 Mar 2013 11:51:00 GMT

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)

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

feyzi — Tue, 05 Mar 2013 12:01:02 GMT

Thank you very much!