topic Re: Can i pass a complete where condition into a macro? in SAS Programming

Re: Can i pass a complete where condition into a macro?

Ron_MacroMaven — Tue, 23 Jun 2015 15:17:38 GMT

reddyr1 wrote:

\begin{question}

%macro eye (eye,dat, id);

data adae ;

set adamdata.adae;

where &cond1;

run;

%mend eye;

The where condition(in red color) needs to be modified for each table.

Eg: where ethnicity="Hispanic"

\end{question}

your problem is that you want to pass a string with an equals sign in it

as a parameter.

change from special character (=) to mnemonic (eq)

%macro eye (eye=,dat=, id=,cond1=);

%put &=cond1;

* ... where &cond1;

run;

%mend;

%eye(eye=,dat=,id=

,cond1=ethnicity eq 'Hispanic');

sbb — Tue, 23 Jun 2015 20:25:54 GMT

Look at using the %quote(....) macro function to enclose your data-passed WHERE logic.

> suggested SAS.COM reference search argument: pass quotes macro invocation site:sas.com

Scott Barry

SBBWorks, Inc.

Reeza — Tue, 23 Jun 2015 20:34:10 GMT

Yes, I asked a similar question a few weeks ago and it seems to work fine. I didn't have to mask anything.

Tom — Tue, 23 Jun 2015 22:45:33 GMT

There is no need to change the parameter DEFINITIONS from positional to named, you can call position parameters by name.

%eye(eye=varx='blue')

You can also add () which should not impact the where clause.