topic Re: Multiple datasets and multiple macro parameters --loop over in SAS Programming

Multiple datasets and multiple macro parameters --loop over

Emma8 — Mon, 28 Oct 2019 23:13:44 GMT

Hello. Can anyone help with the following?

I would like to create one report table for multiple datasets:

proc stdrate data=&MULTIPLEDATA (here I would like to loop through multuple dataset, for example data 1 and data 2)
refdata=&REFDATA(This should unique for each dataset, for example data 1 this refdata=female and for data 2 this refdata=male)
method=direct
stat=rate (mult=100000);
population event=&EVENTS(this also unique for each data as& refdata) total=&population (this also unque for each data as refdata);
reference total=&REF_DATA(also unique for each data);
strata agegroup;
by &VRBL(also unique for each data) notsorted;
ods output StdRate=StdRate;
run;

How can I do that (each data would contain their unique variable and REFDATA also unique data for a given REFDATA.

Thank you.

Re: Multiple datasets and multiple macro parameters --loop over

ChrisNZ — Tue, 29 Oct 2019 21:24:35 GMT

Couldn't you add

proc append base=RESULT data=STDRATE; run;

after your the step shown?

Re: Multiple datasets and multiple macro parameters --loop over

PaigeMiller — Tue, 29 Oct 2019 22:50:23 GMT

So you want to write a loop.

How do we know what the values in &MULTIPLEDATA are that we need to loop through? How do we know the values of &EVENTS are? And so on.

Whwere is this information stored?