Thanks, I will try to look at this and update with findings, In any case your answer gave me addtional confirm it's in the xls and not in the SAS, This is what I found on web, http://www.pharmasug.org/proceedings/2011/CC/PharmaSUG-2011-CC10.pdf our problem is in step#3, also below is our problematic section: /*get names of sheets and put in &SheetNames;*/ data _null_; length MacCmd $200; file xlmacro; %do sh=1 %to &nsheets; MacCmd="=select(!$b$&sh,!$b$&sh)"; put MacCmd; put '=set.name("cell",selection())'; %do wn=1 %to &sh; put '=workbook.next()'; %end; put '=set.value(cell,get.workbook(3))'; put '=workbook.activate("Macro1")'; %end; put '=halt(true)'; put '!dde_flush'; file xl2sas; put '[run("macro1!r1c1")]'; put '[error(false)]'; run; filename sheets dde "excel|macro1!r1c2:r&nsheets.c2" lrecl=1000; data tables; length junk SheetName $500; infile sheets truncover delimiter=']' ; input junk SheetName; /*drop junk;*/ run;
... View more