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

[u63406443]

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.

[Reeza]

Maybe this would be helpful

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

[Kurt_Bremser]

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