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.
Use the FILENAME= option of the INFILE Statement to retrieve the name of the file which is currently read.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.