Can i pass a complete where condition into a dataset present within a macro?I need to use multiple where conditions for the same table which gives out multiple tables for each subgroup.Each where condition needs to use multiple variables.How can i do it?

reddyr1 — Mon, 22 Jun 2015 21:24:09 GMT

%macro eye (eye,dat, id);

data adae ;

set adamdata.adae;

if STUDYGR1 ='Y' and AECAT=&eye and TRTEMFL='Y' and AEBODSYS ne '' 1 ; *'Ocular';

where &cond1;

run;

proc sql ;

/*Number of subjects TRTAN */

create table any as select trtan, count(distinct usubjid) as cnt from adae where trtan ne . group by trtan;

create table soc as select AEBODSYS,trtan, count(distinct usubjid) as cnt from adae where trtan ne . group by AEBODSYS,trtan;

create table pt as select AEDECOD, AEBODSYS, trtan, count(distinct usubjid) as cnt from adae where trtan ne . group by AEDECOD,AEBODSYS,trtan;

quit;

------

%mend eye;

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

Eg: where ethnicity="Hispanic"

where ethnicity="Not Hispanic"

where sex="Female"

where sex="Male"

where agegr1n=1

where agegr1n=2

where agegr1n=3

where agegr1n=4

I need to pass all these where conditions in one program.How can i do that?

Re: Can i pass a complete where condition into a dataset present within a macro?I need to use multip

Reeza — Fri, 11 Sep 2015 14:39:06 GMT

Change the macro to have an additional parameter COND

Create a data set will the parameters you need to call the macro and use call execute

%macro eye (eye,dat, id, cond);

%mend;

Your PROC SQL tables will get overwritten with each run though as they will all have the same name.

My example of call execute:

SAS Documentation example for call execute: