%let subdir=/data/inputfiles/; filename dir "&subdir.*.xls "; data new; length filename fname $ 100; infile dir eof=last filename=fname; input ; last: filename=fname; run; proc sort data=new nodupkey; by filename; run; proc print data=new; run; data x; set new; call symputx(cats('filename',_n_),filename); call symputx(cats('dsn',_n_),compress(scan(filename,-2,'\.'), ,'ka')); if last then call symputx('nobs',_n_); run; proc print data=x; run; %put user; %macro import; %do i=1 %to &nobs; proc import datafile="&&filename&i" out=&&dsn&i dbms=excel replace; getnames=yes; mixed=yes; run; %end; %mend import; %import; 536 %import; WARNING: Apparent symbolic reference NOBS not resolved. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: &nobs ERROR: The %TO value of the %DO I loop is invalid. ERROR: The macro IMPORT will stop executing. 537 Getting this ERROR:
... View more