Unfortunately, this does not work in my case. I use a similar code but within a loop, where I create an excel file in every step:       %let copycmd1 = COPY "&manpath.\Stoch_Vorlage.xls" "&manpath.\Stoch_&klasse..xls" ; 　 data _null_; option noxwait; X &copycmd1; run;   libname excel1 excel "&manpath.\Stoch_&klasse..xls"; PROC Datasets lib = excel1 nolist; delete KLASSE; Quit; 　 Data excel1.KLASSE; set ref_&jj; run; 　 　 　 libname excel1 clear; 　 PROC Delete data = work.ref_&jj; %end;   Log tells me my prepared data sheet 'KLASSE' would not exsist and creates a new one 'KLASSE1'   NOTE: Libref EXCEL1 was successfully assigned as follows: Engine: EXCEL Physical Name: Q:\[correct directory]\Stoch_12_42 .xls MPRINT(ALLKLASSE): PROC Datasets lib = excel1 nolist; MPRINT(ALLKLASSE): delete KLASSE; MPRINT(ALLKLASSE): Quit; NOTE: The file EXCEL1.KLASSE (memtype=DATA) was not found, but appears on a DELETE statement. NOTE: PROCEDURE DATASETS used (Total process time): real time 0.01 seconds cpu time 0.00 seconds   Result: in Stoch_12_42 .xls, KLASSE is not replaced, but the data has been added in a new sheet KLASSE1.   There are references from graphics to KLASSE which I do not want to calculate individually but to be created in each loop step respectively.   Thanks   Gregor     ... View more

Thanks! ... View more

Hi Chad, Many thanks. Yes, it worked for Excel 2003. /*When you import several sheets from a Excel 2003 workbook, I found below macro code works….*/ %macro name1 (one,two); PROC IMPORT OUT=work.&one             DATAFILE="\\xxxx-xx-sas01\abc\myfiles\testing.xls"             DBMS=xls REPLACE;      GETNAMES=YES;      SHEET="&two"; /*SHEET= option is acceptable */ RUN; %mend name1; %name1 (file1,Sheet1); %name1 (file2,Sheet2); %name1 (file3,Sheet3); But for Excel 2010, the macro I have shown below did not work. I do not know why. But when I imported one sheet at a time (without macronizing) then it worked. So, no problem I can import Excel 2010 sheets one at a time. /*IMPORT EXCEL 2010*/ /*BELOW MACRO CODE DID NOT WORK????*/ /*When you import several sheets from a Excel 2010 workbook, I found below macro code DID NOT WORK….*/ /*But worse comes to worse you can import 3 sheets one by one, one at a time without macronizing*/ %macro name2 (three,four); PROC IMPORT OUT=WORK.&three             DATAFILE="\\xxxx-v7-sas01\xyz\mydata\testing.xlsx"             DBMS=EXCELCS REPLACE;    /* GETNAMES=YES;*/ /*You cannot use GETNAMES=YES; in this code*/      SHEET="&four"; /*SHEET= option is acceptable */ RUN; %mend name2; %name2 (file4,Sheet1); %name2 (file5,Sheet2); %name2 (file6,Sheet3); Thanks everybody for all these helps! Mirisage ... View more

It's handy when you want to render the LOG useless.  Or if you're programming for job security. ... View more