Macros with conditions

brophymj — Tue, 14 Oct 2014 10:15:36 GMT

I have a data set with a field called Key which has values ranging from 1 to 25 and these represent different conditions;

Condition one is: if Fieldx = 1 then let comment = "exclud"e

Condition two is: if Fieldx = 2 and Fieldy ne 4 then comment =" always include"

and so on.

So the conditions vary in terms of the number of fields that affect the condition

I want to build a macro like;

%macro test(condition);

data test;

set test;

if &condition;

run;

%mend;

%test(fieldx=2);

%test(fieldx=2 and fieldy ne 4);

Something like this but which works.

Basically I can do this very simply if there is only one field affecting the condition but if it varies is there a way of building this into the macro

Re: Macros with conditions

arodriguez — Wed, 15 Oct 2014 10:40:17 GMT

Hi,

Have you tried to use the function %STR()? All macro should work if you call it like

%test(%STR(fieldx=2));

%test(%STR(fieldx=2 and fieldy ne 4));

Re: Macros with conditions

brophymj — Wed, 15 Oct 2014 10:57:38 GMT

Thanks a million, that worked!

topic Re: Macros with conditions in SAS Procedures

Macros with conditions

Re: Macros with conditions

Re: Macros with conditions