Hello Keshan, Thanks so much for your response. However, I got this error "ERROR: No logical assign for filename XXXXXXX." when I executed the code below: --------------------------------------------------------------- Data collegesummary; input college $ program $ report $; cards; LLL Chinese Yes LLL English No LLL Spanish Yes LLL Korean No Engineering Mechanical Yes Engineering Chemical Yes Engineering Electrical No ; run; title; %let dir = "C:\Users\Desktop\"; proc sort data=collegesummary(keep=college) out=unique nodupkey;by college ;run; %macro repeat(dir=xxxxxxx,dsn=xxxxxxxx,group=xxxxxxxx); ods rtf path=&dir. file="&dsn&sysdate..rtf" ; proc report data=collegesummary nowd; where college="&group"; column program report; define program/display; define report/display; run;quit; ods rtf close; %mend repeat; data _null_; set unique; call execute('%repeat(dir=xxxxxxx,dsn='||strip(college)||',group='||strip(college)||')'); run; -------------------------- This looks very promising. I'd appreciate any solution to this error. Thanks, Yao
... View more