Assign a libref to the path specified. (where the actual datasets reside i.e. .sas7bdat files and use that libref to do your stuff. libname myLib ''C:\Users\Danny\Documents\My SAS Files\9.3" ; data temp; set myLib.question03 ; run; proc print data=temp; run; ... View more

Hi, As you mentioned Local symbol table has val3=MTEST and the scope variable in proc print will be having the scope of MTEST only , not GLOBAL because the global macro variable will be overwritten with local macro variable if it is with same name..I took a sample data and checked which might help you. %let val3=GLOBAL; data test; input var $ scope $; cards; var1 LOCAL var2 GLOBAL var3 LOCAL ; run; options symbolgen; %macro mtest(val1,val2,val3=MTEST); title "Listing of &val3 Macro Variables"; proc print data=&val1; where scope="&val3"; Var &val2; run; %mend; %mtest(test,var); /* This macro returns val3=MTEST only */ %mtest(test,var,val3=&val3); /* here i have declared val3 will take the global macro variable value as GLOBAL */ PLease find the snapshot for the below macro output. ... View more