I tried the solution posted by Data _null_ above. Still the same issue. - SMR ... View more

I was able to create a macros to compile the list of files in my directory, just to see if that was the issue. /*compiled directory*/ %macro get_filenames(location);    filename pipedir pipe "dir ""%unquote(&location)"" /b";    data files;      infile pipedir truncover;      input filename $256.;      put filename=;    run;    filename pipedir clear;  %mend; %get_filenames(C:\Users\Owner\Desktop\SAS Project\ACL CSV files) Unfortunately I'm still running into the same issue with the previous syntax, even after adjusting the infile statement. Are there any examples of alternative syntax (with or without macros) you recommend looking at, or if your willing to show me how to arrange what I have in a way that might be more efficient? - SMR /*adjusted syntax*/ options mprint; %macro MultImp(dir=,out=);   %let rc=%sysfunc(filename(mydir,&dir));   %let did=%sysfunc(dopen(mydir)); %put dir=&dir; %put did=&did;   %let filrf=MYDIR;   %let lstname=;   %let memcount=%sysfunc(dnum(&did));   %if &memcount > 0 %then %do;   %do i=1 %to &memcount;   %let lstname=%sysfunc(dread(&did,&i));   %let file=&dir.&lstname; data files;   infile "dir ""&mydir\BTLT4-*.csv"" /b" pipe truncover;   input filename $256.;   run;   proc append data=_&i base=&out; run;   proc delete data=_&i; run;   %end;   %let rc=%sysfunc(dclose(&did));   %end;   %mend MultImp;   %MultImp(dir=C:\Users\Owner\Desktop\SAS Project\ACL CSV files\,out=File); ... View more

After replacing the PROC IMPORT statement to the syntax below I'm still getting the following error. dir=C:\Users\Owner\Desktop\SAS Project\ACL CSV files\ did=0 WARNING: Argument 1 to function DNUM referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range. NOTE: Mathematical operations could not be performed during %SYSF BTW, thanks for your help thus far! As a beginner with SAS macro all help is appreciated. - SMR options mprint; %macro MultImp(dir=,out=);   %let rc=%sysfunc(filename(mydir,&dir));   %let did=%sysfunc(dopen(mydir)); %put dir=&dir; %put did=&did;   %let filrf=MYDIR;   %let lstname=;   %let memcount=%sysfunc(dnum(&did));   %if &memcount > 0 %then %do;   %do i=1 %to &memcount;   %let lstname=%sysfunc(dread(&did,&i));   %let file=&dir.&lstname;   data want;    length var1 var2 ..... var167 ;    infile "&mydir\BTLT4-*.csv"  dsd truncover lrecl=32000;    input @;    if upcase(_infile_)=:'VAR1,' then delete;    input var1 --- var167 ;   run;   proc append data=_&i base=&out; run;   proc delete data=_&i; run;   %end;   %let rc=%sysfunc(dclose(&did));   %end;   %mend MultImp;   %MultImp(dir=C:\Users\Owner\Desktop\SAS Project\ACL CSV files\,out=File); ... View more

After including %put &did; into my syntax, I was indeed given a value of 0. What can I do to fix this? - SMR As a reminder, this is the error I receive for the syntax above. WARNING: Argument 1 to function DNUM referenced by the %SYSFUNC or %QSYSFUNC macro function is out          of range. NOTE: Mathematical operations could not be performed during %SYSFUNC function execution. The       result of the operations have been set to a missing value. 0 ... View more