Check if this helps for you. Change the import for the files you have (In my case xlsx files)
%let Path=<Your path here>;
/* Read all the files that are in a specific folder */
FILENAME _folder_ "%bquote(&path.)";
data filenames(keep=memname);
FORMAT memname $100.;
handle=dopen( '_folder_' );
if handle > 0 then do;
count=dnum(handle);
do i=1 to count;
memname=dread(handle,i);
output filenames;
end;
end;
rc=dclose(handle);
run;
filename _folder_ clear;
/* Count total files in the location and add all the file names into a macro */
PROC SQL noprint;
SELECT COUNT(*),memname INTO: Total_Files, : All_Files separated by "," FROM filenames;
QUIT;
%PUT "Total Files:" &Total_Files "All Files:" &All_Files;
/* Close files if they are opened before importing into SAS. If they are not closed then you may get an error */
/* If you get error then try re-running it aganin */
%MACRO CLOSE_FIELS();
%DO I=1 %TO &Total_Files ;
%LET File=%SCAN("&All_Files",&i,",");
%let filrf=myfile;
%let rc=%sysfunc(filename(filrf,&path./&FILE.));
%let fid=%sysfunc(fopen(&filrf));
%if &fid > 0 %then
%do;
%let rc=%sysfunc(fread(&fid));
%let rc=%sysfunc(fclose(&fid));
%end;
%else
%do;
%put %sysfunc(sysmsg());
%end;
%let rc=%sysfunc(filename(filrf));
%END;
%MEND;
%CLOSE_FIELS;
/* Macro to import all the files from path to SAS */
/* If you get an error then re-run this code again. If the excel file is opened then you may get an error */
%MACRO IMPORT_FILES();
%DO I=1 %TO &Total_Files ;
%LET File=%SCAN("&All_Files",&i,",");
proc import
datafile="&path./&File."
dbms=xlsx
out=GRIDWORK.TASK&i.
replace;
RUN;
%END;
%MEND IMPORT_FILES;
%IMPORT_FILES();
/* Append imported data into a single dataset */
%MACRO APPEND();
%DO I=2 %TO &Total_Files;
PROC APPEND BASE=GRIDWORK.Task1 DATA=GRIDWORK.Task&i. FORCE;
RUN;
%END;
%MEND APPEND;
%APPEND();
Thanks,
Suryakiran
