Loop multiple data using proc stdrate

Emma8 — Tue, 29 Oct 2019 02:10:34 GMT

Hello. Can anyone help with the following report. I would like to create as the attached report by using from 1 to multiple data-sets the following macro parameters which are unique for each data-set:

proc stdrate data=&DATA (data 1 and data 2).
refdata=&REFDATA (data 1a and data 2a).
method=direct
stat=rate (mult=100000);
population event=&EVENTS (for data 1 it is cancer 1 and for data 2 it is cancer 2) total=&POPULATION. ( there are 2 different variables from data-sets (data 1a and data 2a));
reference total=&REF_TOTAL. (variable female from data 1a and overall from data 2a) ;
strata agegroup;
by &COHORTS (in the example, those are gender and race) notsorted;
ods output StdRate=StdRate;

quit;
run;

Thank you.

Re: Loop multiple data using proc stdrate

Tom — Tue, 29 Oct 2019 02:59:05 GMT

Get the code to work for one set of values (datasets, variables etc).

Then change the variable part to use macro variable references (which is kind of like your posted pseudo code). Just set the macro variable values with %LET statements at the top. Get that to work for the same example values.

%let data=data1;
%let refdata=data1a;
....
proc stdrate 
  data=&data
  refdata=&refdata
...

Then remove the %LET statements and wrap the code into a macro using the names of those macro variables as the parameters to the macro. Convert the %LET statements into the values of the macro in the call to the macro. Again get that to work for your example.

%macro mystdrate
(data=
,refdata=
...
);
proc stdrate 
  data=&data
  refdata=&refdata
...

%mend;

%mystdrate
(data=data1
,refdata=data1a
...
);

Then just call the macro multiple times with each of your combinations of values.

%mystdrate
(data=data2
,refdata=data2a
...
);

If you actually have the list of values in a dataset then you can use the dataset to generate the calls. But if you don't have the dataset it is not really worth making it. Just write the individual macro calls.

topic Loop multiple data using proc stdrate in New SAS User

Loop multiple data using proc stdrate

Re: Loop multiple data using proc stdrate