Skip to content
Advertisement

SAS SQL using a where condition with macro variable

I have a proc sql procedure in SAS where my where clause should be dynamic (the set of ID numbers will be updated in the future).

I could do something as follows for a unique character condition:

However, how could do the same to check several numbers? How could I make the following work?

Advertisement

Answer

Resolve the value of VALUE2 before execution.

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement