topic Re: Scan keyword in multiple SAS program files in SAS Programming

Scan keyword in multiple SAS program files

Codexgo — Wed, 18 Nov 2020 06:35:59 GMT

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

Re: Scan keyword in multiple SAS program files

Kurt_Bremser — Wed, 18 Nov 2020 06:55:12 GMT

I always do this

cd directory_with_program_files
grep keyword *.sas

(SAS server runs on AIX)

Re: Scan keyword in multiple SAS program files

FreelanceReinh — Wed, 18 Nov 2020 09:30:32 GMT

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.

Re: Scan keyword in multiple SAS program files

Codexgo — Thu, 19 Nov 2020 09:18:04 GMT

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;

Re: Scan keyword in multiple SAS program files

Kurt_Bremser — Thu, 19 Nov 2020 09:30:10 GMT

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.

Re: Scan keyword in multiple SAS program files

Codexgo — Thu, 19 Nov 2020 10:04:28 GMT

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

Re: Scan keyword in multiple SAS program files

Kurt_Bremser — Thu, 19 Nov 2020 10:20:21 GMT

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