Hi All, My requirement is to import data from a number of .csv files into a SAS data set. I am using the following code to do the same. The .csv files ( 5 in number namely DATROCF1,DATROCF2,DATROCF3,DATROCF4,DATROCF5) ) have been placed in the shared path. The issue which I am facing is that. the dataset 'DATRDOCF' has data only from the 5th file in the path. and not from all the files. Can you please help me out. %let subdir=F:\pol\New folder\;
filename dir "&subdir.*.csv ";
data new;
length filename fname $ 200;
infile dir eof=last filename=fname;
input ;
last: filename=fname;
run;
proc sort data=new nodupkey;
by filename;
run;
data null;
set new;
call symputx(cats('filename',_n_),filename);
call symputx(cats('dsn',_n_),compress(scan(filename,-2,'\.'), ,'ka'));
call symputx('nobs',_n_);
run;
%put &nobs.;
%macro import;
%do i=1 %to &nobs;
proc import datafile="&&filename&i" out=&&dsn&i dbms=csv ;
getnames=yes;
run;
%end;
%mend import;
%import
... View more