Get a list of all the files and folders from a single directory into a SAS data set, in one hit. Really useful for iterating over later.
Real quick one to get a directory listing into SAS, if you want to know more about how it works, check out this.
Specify the directory to list using the
location macro variable.
%Let location = C:\Program Files; *no need to wrap this in quotes; FileName myDir Pipe "dir ""&location"" /b"; *gaps in path handled by double-double quote here; Data listing; InFile myDir Length=lineLength; Input file $varying512. lineLength; Run;
Looping over the Directory
Use the dynamic loop from here to loop over your directory contents. If you’ve got a directory of flat files that all need to go through a
Proc Import, they can now be named absolutely anything and it won’t matter in your code!