Hi Kannan I have just tried the below: %macro new2(ot=, SD=, ED=); in the pass through sql: WHERE syndicate_share.syndicate_share_timestamp >= &SD and syndicate_share.syndicate_share_timestamp <= &ED %mend new2; %new2 (ot=work.a, SD='01Oct2015', ED='31Oct2015') ; IT's WORKING NOW!!! Thanks you very much for reaching out. Rgds Rimon
... View more