Scan keyword in multiple SAS program files

[Codexgo]

Hi Folks,

How can i scan list of keywords on multiple SAS programs files. By SAS or Shell Script or any other way to achieve it?

Thanks

[Kurt_Bremser]

I always do this

cd directory_with_program_files
grep keyword *.sas

(SAS server runs on AIX)

[Codexgo]

Hi Kurt,

I am trying below mentioned code in SAS but its not working. Also if i want to search more than one keyword - e.g. along with libname, infile, import, how to do it ?

Thanks.

filename find 'grep "libname" Path*.sas';

data test;
infile find truncover;
input find_words $100.;
run;

[Kurt_Bremser]

You missed a keyword:

filename find pipe 'grep "libname" Path*.sas 2>&1';
data test;
infile find truncover;
input find_words $100.;
run;

I also added a redirection of stderr to stdout, so that all possible responses will be caught in the data step.

[Codexgo]

HI Kurt,

I am getting this error while executing the code: 

ERROR: Insufficient authorization to access PIPE.

ERROR: Error in the FILENAME statement.

74 data test;

75 infile find truncover;

76 input find_words $100.;

77 run;

ERROR: No logical assign for filename FIND 

[Kurt_Bremser]

Then you have, unfortunately, XCMD disabled. Get in touch with your SAS admins to have it enabled.

[FreelanceReinh]

Hi @Codexgo,

A "cousin" of grep in the Windows world is findstr (to be used on the command line, cmd.exe):

findstr "keyword1 keyword2 ..." *.sas

would find all lines in .sas files in the current folder containing one or more keywords from the list. Various options could be specified to modify the search, e.g., /s to extend it to all subfolders.

Similar functionality ("Find in files") is offered by some text editors (and other utility software) and, of course, you could write a SAS program for this purpose. I mostly use findstr.