Hello. I intend to get a dataset by appending many outputs of PROC FREQ with each variables and the outcome. Although the number of iteraition is about 50,000, it takes half a day. Could you tell me the better way for calculating faster ? I appreciate your kindness helping. The program is as following: ////////////////////////////////////////////////////// %macro outtest(outcome=); *; %let dsid=%sysfunc(open(a1,i)); %let vnum=%sysfunc(attrn(&dsid,nvars)); %let rc=%sysfunc(close(&dsid)); *; *; %do no=1 %to &vnum; proc freq data=a1 noprint; output out=nout&no trend exact; tables &outcome*numgeno&no / exact trend; run; %end; *; data n1; set nout1; run; *; %do no=2 %to &vnum; proc append base=n1 data=nout&no force; run; %end; *; %mend; *; %outtest(outcome=COL1D); ////////////////////////////////////////////////////// Best regards,
... View more