topic searching string through programs in SAS Procedures

searching string through programs

jplarios — Thu, 02 Jul 2009 14:11:42 GMT

I want to search through a bunch of sas programs and find one word strings. The ouput dataset called found contains the job that has the matching string.
This is one way I approached it but get stock when trying to output or using the filevar:

I created a proglist text file that contains all my programs ( more than a 100) which I loaded them into a sas data set named progs. I take this progs set and

data progs;
infile proglist;
input @1 program $88.;
run;

filename name '/dir/';

data found;
set progs;
prog = '/dir/'||program;
infile name filevar=prog end=done;
do while (not done);
if index(_INFILE_, "FINDTHIS") > 0 then do; found = 1;output; end;
end;
run;

Re: searching string through programs

sbb — Thu, 02 Jul 2009 15:36:33 GMT

Your SAS program needs an INPUT; statement to load the input buffer before you can reference _INFILE_.

Scott Barry
SBBWorks, Inc.

Re: searching string through programs

jplarios — Thu, 02 Jul 2009 19:38:10 GMT

Scott,
Thank you!
Juan

Re: searching string through programs

deleted_user — Tue, 07 Jul 2009 01:47:22 GMT

Juan -
If you only wanted to get one observation per file then you could add a little more logic to your do loop.

found=0;
do while (not done and not found);
if index(_INFILE_, "FINDTHIS") > 0 then do; found = 1;output; end;
end;

- Tom