Thank you!
I imported only 1 file without macros and it worked. The log response was
NOTE: The import data set has 49 observations and 5 variables.
NOTE: WORK.DATAFILE1 data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.25 seconds
cpu time 0.01 seconds
Then I ran the macro again and got this as the log response:
NOTE: The infile DIRLIST is:
Unnamed Pipe Access Device,
PROCESS=dir "C:\HW5"\,RECFM=V,LRECL=32767
NOTE: 12 records were read from the infile DIRLIST.
The minimum record length was 0.
The maximum record length was 53.
NOTE: The data set WORK.FILES has 12 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.01 seconds
I am trying to import 3 files and all files have more than 30 observations. I am not sure what it is referring to when it says "NOTE: The data set WORK.FILES has 12 observations and 1 variables."
The following is the whole program after the changes you had suggested.
****** 1. Get file lists in the directory*;
filename dirlist pipe 'dir "C:\HW5"\';
****** 2. Resolve file names to SAS dataset "files" *;
data files;
length fname $9;
infile dirlist truncover length= reclen;
input fname $varying9. reclen;
run;
******* 4. Import all the files we want into SAS dataset*;
%macro fileinput (csvfile=);
* Excel file import*;
proc import out= workingset
datafile= "&csvfile"
dbms=xlsx replace;
range="sheet1$";
run;
%if %sysfunc(exist(workingset_finale)) %then %do;
proc append base=workingset_finale data=workingset;
run;
%end;
%else %do;
data workingset_finale;
set workingset;
run;
%end;
%mend;
data _null_;
set files nobs= nobs;
call execute ('fileinput(csvfile='||fname||');
run;
