Hi there,   I would like to export the dataset to multiple excel files based on a certain variable: --------------------- proc sql; create table try as select distinct make from sashelp.cars; proc sql; create table try2 as select count(make) as aaa from sashelp.cars;   data _null_; set try; by make; call symputx ('make',compress(make,' .'),'g'); run; data _null_; set try2; call symputx('n',aaa); run;   %macro a; %do i=1 %to &n; %let var= %scan(&make,&i,"@"); proc export data=testing (where=(make="&make.")) outfile="C:\Users\&make..xlsx" dbms=xlsx replace; sheet="&make." ; run; %end; %mend ; %a; ------------------------------------------------------ My goal is to get all the 38 excel files with the maker name as the filename. However, all I am able to get here is the last maker name's file. Would you please point out where I am missing out here? Many thanks!! ... View more