Hi all, I have seen many posts and answers for my query, those are not helping me. I'm using remote sas server, sas 9.3 version. all datasets similar variables. here is my query for an example : have 20 datasets. I want to export all datasets into one excel workbook with 20 sheets. when I use dbms=xlsx below code last 20th dataset only comes in output. &&_table&i. it contains all the 20 datasets names. cnt has value of 20 here is my peice of code : %do i = 1 %to &cnt; PROC EXPORT DATA= &&_table&i. outfile= "pathwhereiwant to store.xlsx" dbms=XLSX replace; sheet="&&_table&i."; run; %end; i have used libname method not working ERROR: The XLSX engine cannot be found. ERROR: Error in the LIBNAME statement. expecting resolution from experts. Thank you
... View more