I think that wutao9999 want to write in a specific sheet of an existing excel file (at lest is what i also need to do), for what i read from Hima's link seems that SAS when want to write in a specific sheet try to create it , and if the name that we want to use is alredy in used SAS add a numeric character to avoid the duplication... so, this mean that i have no way to export a data set in a specific sheet in a alredy existing excel file? thank a lot Davide just to be sure i add the code that i'm using proc export data = test outfile = "C:\test\fileexcel.xlsx" DBMS = EXCEL REPLACE; SHEET = "foglio1"; run;
... View more