I currently have this SAS program: %let i = 1; %macro test; %let x = %scan(&idlist,&i,'*'); %do %until (&x= ); %put "&x"; ods html file="/sasdata//temp&x .xls" headtext="<style> td {mso-number-format:\@}</style>"; proc print data=libanme.tablename uniform label; var col1 col2 col3 col4 col5; where col1 ="&x"; run; ods html close; %put "&x"; %let i = &i +1; %let x = %scan(&idlist,&i,'*'); %end; %mend test; %test; This program creates a separate xls file in each iteration. My objective is to create a single dataset and append result of each iteration to that dataset and create a single output xls file containing the entire dataset.
... View more