How to search for SAS files in a drive

malena — Wed, 13 Feb 2019 16:38:05 GMT

I am trying to get a list of all SAS files (with path names) on a drive and I am using the code that was I found on here of someone trying to do what I need to do- but I it is not working-

filename search pipe 'for /r U:\REPI\population\saspop %i in (*.sas7bdat) do @findstr /i /m "obs=max" "%i"';

data search_results;
infile search length=_len;
input @1 filepath $varying512. _len;
run;

NOTE: The infile SEARCH is:
Unnamed Pipe Access Device,
PROCESS=for /r U:\REPI\population\saspop %i in (*.sas7bdat) do @findstr /i /m "obs=max" "%i",
RECFM=V,LRECL=256

NOTE: 0 records were read from the infile SEARCH.
NOTE: The data set WORK.SEARCH_RESULTS has 0 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 9:31.21
cpu time 0.06 seconds

Re: How to search for SAS files in a drive

Reeza — Wed, 13 Feb 2019 16:51:35 GMT

What is your OS? Did you try the PIPE command on it's own to ensure it runs? Otherwise, try the simpler approach here: https://support.sas.com/kb/45/805.html

Re: How to search for SAS files in a drive

malena — Tue, 19 Feb 2019 14:13:43 GMT

thank you! that worked!!

topic Re: How to search for SAS files in a drive in SAS Programming

How to search for SAS files in a drive

Re: How to search for SAS files in a drive

Re: How to search for SAS files in a drive