Hi there,
I would like print to Excel sheets 380 tables "sas" by using 4 "proc FREQ"
This is my program :
ods tagsets.EXCELXP file="D:\S\&school.xls" ;
%macro test ;
%do cpt = 1 %to 95 ;
%if &cpt =1 %then %let school =0372604S ;
%if &cpt =2 %then %let school =0370049P ;
%if &cpt =3 %then %let school =0370002N ;
proc freq data= a.table (where=(school="&school"));
table school*var1*var2*var3/ missprint nocol nopercent nofreq norow noprint out= sasuser.tbx1&school ;
format school $school. ;
run;
ods tagsets.Excelxp close;
%end ;
%mend ;
%test ;
Could you please find out any anomalies in this program, and if you could
propose any alternatives that could fix this program.
Thank for your assistance in advance.
... View more
