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. ... View more

Hi All,   I am trying reading  the entire SAS  program (.sas files) and storing entire program code in the dataset using option filename statement, but here problem is it is not able to fetch all lines of code instead fetching few lines. Can anyone please help me?   code: filename rd 'C:\Users\rakes\Documents\My SAS Files\sas_practice\program_2.sas'; data temp; infile rd; input rec $150.; run;   Thanks, Rakesh. ... View more

Hi All,   I am trying to connect with database using libname statement, for that I have created a macro variables and those variables is not fetched in libname statement. Can you all please look into the code and help me resolve the issue.   See difference in below two  libname statements in a password field. code: %let user=%str(rakesbx); %let password=%str(rAk%B25%); /*Libname cdl1 odbc datasrc="cdl2-hive" schema= abv_hcp360_besting_lease_ext user= "&user" password= "rAk%B25%";*/ ---> when I am trying these way and commenting the password variable  it is giving the result i.e.,:   Success result is:     Libname cdl2 odbc datasrc="cdl2-hive" schema= abv_hcp360_opt_preference_ext user= "&user" password= "&password"; ----> when I am trying these way it is not giving the result i.e.,   Error result is:   Thanks.   ... View more

Hi All,   I am try to declare a macro variable and print the macro variable in log window using the put statement, but output is not fetching. Can you help me. Attaching the output image for reference.   Code: %let pass=%str(rAk%B25%); %put &pass;   Thanks.   Result:     ... View more