Thank you all for your responses and ideas! This is how I finally solved it. -------------------------------------------------------------------------------------- %MACRO domean; %DO I = 1 %TO 100; proc surveyselect data=baseline_followup out=controlmac&i method= srs sampsize=250; run; data controlmac&i; modify controlmac&i; Ycat=0; run; data casecohort&i; set case controlmac&i; run; ods trace on; proc freq data=casecohort&i order=formatted; table xcat*ycat/relrisk; run; ods trace off; ods output RelativeRisks=Output&i; proc freq data=casecohort&i order=formatted; table xcat*ycat/relrisk; run; proc print data=Output&i noobs; run; %END; %MEND domean; %domean data allrelrisk; set output1-output100; run; data onlyodds; set allrelrisk; where studytype not like 'Co%)'; run; proc means mean data=onlyodds; run;
... View more