Stored 10 SAS Programs in data step need output result with filtered word and full path.

u63406443 — Mon, 27 Nov 2023 16:25:35 GMT

Hi All,

I am trying reading the total of 10 SAS program (.sas files) and storing entire 10 SAS program codes in the dataset using option filename statement, and finally filtering the words based some criteria and I am able to do that, i getting output result as filter word, but here problem is i need to get the full path name with whose filtered word condition is satisfied.

code:

filename rd

('C:\Users\rakes\Documents\My SAS Files\sas_practice\program_2.sas' ,

'C:\Users\rakes\Documents\My SAS Files\sas_practice\program_3.sas' ,

'C:\Users\rakes\Documents\My SAS Files\sas_practice\program_4.sas' ,

like so on----

);

data temp;
infile rd truncover;
input rec $150.;

if index(lowcase(rec), "metafix") ne 0 then output;
run;

Result:

rec - column name

---

metafix

metafix is good

But i need as

Actual result

-------------

rec,fpath -- column names

metafix <filepath>

metafix is good <filepath>

Thanks,

Rakesh.

Re: Stored 10 SAS Programs in data step need output result with filtered word and full path.

Reeza — Mon, 27 Nov 2023 18:00:08 GMT

Maybe this would be helpful

https://gist.github.com/statgeek/26cf789d6da0ce941e447022fdccf0f4

Re: Stored 10 SAS Programs in data step need output result with filtered word and full path.

Kurt_Bremser — Mon, 27 Nov 2023 19:25:29 GMT

Use the FILENAME= option of the INFILE Statement to retrieve the name of the file which is currently read.

topic Re: Stored 10 SAS Programs in data step need output result with filtered word and full path. in SAS Programming

Stored 10 SAS Programs in data step need output result with filtered word and full path.

Re: Stored 10 SAS Programs in data step need output result with filtered word and full path.

Re: Stored 10 SAS Programs in data step need output result with filtered word and full path.