@blaubner wrote:
Sorry, I wasn't specific enough.
I don't want to designate a library and hard code the actual file names. I want a procedure to be automated. When the program is executed, it would...
1. collect the filenames from a directory and put them into work.fakeset under the variable 'fname' (I've achieved this)
2. The program then brings in all the files from the directory using each 'fname' into one new data set called work.alldata
Does that make sense?
So, let's assume you know the folder name but you don't know the names of the SAS files in the folder ... is that a valid assumption?
If so
libname mylib 'Fake\Path';
proc sql noprint;
select distinct cats('mylib.',memname) into :tablenames separated by ' '
from sashelp.vtable where libname='mylib';
quit;
data want;
set &tablenames;
quit;
... View more
