Hi, I tried following the similar steps but the exported xls is not showing any data. Please find my code below: %macro export_data = (file=,data=,sheet=); proc export data= "&data." outfile= "&file." dbms=xls replace; sheet="&sheet."; run; %mend export_data; %export_data (file= "D:\SAS\export_files\multiexp.xls",data= sashelp.class,sheet= class); %export_data (file= "D:\SAS\export_files\multiexp.xls",data= sashelp.cars,sheet= cars); run; thank you!!!
... View more