Hi,
As @Reeza has stated, add one procedure to your datastep and avoid all that messy code:
data outdir.imp_lkup_files;
length dsn $40 xlsheet $20 filenm $150;
infile datalines DSD Delimiter='|';
input dsn $ xlsheet $ filenm $;
/* Here */
call execute(cat('proc import datafile=',strip(filenm),' out=',strip(dsn),' dbms=xlsx replace; sheet="',strip(xlsheet),'"; getnames=yes; run;'));
datalines;
outdir.Feb|planf|K:\user\plan_f_20160204
outdir.Mar|planm|K:\user\plan_m_20160322
outdir.Apr|plana|K:\user\plan_a_20160407
;
run;
... View more