Dear ALL, Try the simple code as follows: %let n = 2; data all; run; %macro test; %do i=1 %to &n; Proc Import Out= result&i Datafile="E:\IAR_Rept&i..xlsx" Dbms=Excel Replace; Getnames=Yes; Mixed=No; Scantext=Yes; Usedate=Yes; Scantime=Yes; Run; data all; set all result&i; run; %end; %mend; %test;
... View more