topic Re: where statement in a macro in SAS Programming

where statement in a macro

wisej — Mon, 05 Apr 2021 19:13:34 GMT

Hi,

I am using a macro to run PROC FREQs for a descriptive statistics table to be used in a paper. I am trying to run the same PROC FREQ for different IDs, so I am using a where statement within the macro. The code I am using is pasted below - when I run this code, SAS tells me "keyword parameter ID was not defined within the macro." I appreciate any help!!

%macro analysis(dataset,variable,condition);
proc freq data=&dataset;
tables &variable;
where &condition;
run;
%mend analysis;
%analysis(biweekly,amount_food_consumed,ID="LION-1");

Re: where statement in a macro

Tom — Mon, 05 Apr 2021 19:16:51 GMT

The macro call:

%analysis(biweekly,amount_food_consumed,ID="LION-1");

Is referencing a macro parameter named ID, but the macro does not define a parameter named id.

Call the CONDITION parameter by name instead.

%analysis(biweekly,amount_food_consumed,condition=ID="LION-1");

Or add parentheses into the condition value.

%analysis(biweekly,amount_food_consumed,(ID="LION-1"));

Re: where statement in a macro

wisej — Mon, 05 Apr 2021 19:14:32 GMT

That worked - thank you so much!