Thank you so much Shiva 🙂 It worked, i did the following 1) Just changed the code as strip instead of trim 2) and i given the parameter with double quotes as you specified in the picture The code looks like below /*********************************** Start of SAS Code ***********************************/ data WORK.path; infile '/sasdata/env3/lev1/data/BRM/Paremeter_Check.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ; informat source $8. ; informat path $100. ; format source $8. ; format path $100. ; input source $ path $; run; proc sql; create table work.parameter as select distinct source,path from path; quit; data _NULL_ ; set work.parameter; call execute ('%global ' || strip(source)); call execute ('%LET ' || strip(source) || '=' || strip(path)); run; %put &Client &Policy; /*********************************** End of SAS Code ***********************************/ and in where condition i have given "&Client" Thank you so much
... View more