As is usually the case in SAS, there may be multiple ways to achieve each of these goals, but frequently an efficient, reproducible method will involve interface between the DATA step and the Macro facility. In this paper, I am going to introduce a CALL routine and a SAS function that ...
the where statement as you mentioned the macro variables will get resolved but when you use some options like symbolgen mprint and mlogic in your code these password values will get exspodes in the sas log and that is i why i am trying to mask those variables using SYMGET function. i...