It is official, it's a defect! Maybe there will be a fix or it will be included in a later version. Here is the example code: %let tot=10000; data pippo; format a 8. b $32.; do i=1 to &tot.; a = i; b = "ciao" || put(i, 8.); output; end; drop i; run; %macro test; %do i=1 %to &tot.; data pluto; set pippo; WHERE a=&i.; run; proc export data=pluto OUTFILE="c:\appo\test\test_&i..xlsx" DBMS=xlsx REPLACE LABEL; run; %end; %mend; %test;
... View more
