sas macro
By Subhro Kar
IN operator is used in the data step to replace multiple OR conditions.
IN Operator is not available in Macro Language
In macros, the IN operator fails to execute.
ERROR: Required operator not found in expression: &names in(‘Alice’,’James’,’John’,’Judy’) ERROR: The macro TEST will stop executing.
By Subhro Kar
Solution
By Subhro Kar
1. MINOPERATOR
2. MINDELIMITER
Enabling this option, you can use the IN (#) operator with the list of values.
It is used to specify the delimiter for the list of values used in the IN operator.
to use the IN operator inside a macro, there are 2 system options you need to specify.
By Subhro Kar
The list of values can be used with the IN (#) operator.
By Subhro Kar
It is used to specify the delimiter for the list of values used in the IN operator.
%macro macroname / mindelimiter=',';
options minoperator; options mindelimiter=',';
OR
By Subhro Kar
0218
By Subhro Kar