topic IN Operator with SAS Variables in SAS Programming

IN Operator with SAS Variables

CurtisER — Wed, 02 Mar 2022 17:40:19 GMT

Hello, I just wanted to be sure that I cannot use SAS variables in an IN operator in a Data Step?

Let's say that I have 3 SAS variables:

a = 'Mazda';
b = 'Kia';
c = 'Nissan';

if MAKE in (a, b, c);

I get a syntax error.

I know I can write as literals:

if MAKE in ('Mazda', 'Kia', 'Nissan');

I wanted to verify that using SAS variable is not possible in a DATA step. Thanks.

Tom — Wed, 02 Mar 2022 17:43:52 GMT

Two work arounds.

The IN operator works with an ARRAY reference.

array makes a b c;
if make in makes ;

Use the WHICHC() function.

if whichc(make,of a b c) ;

PaigeMiller — Wed, 02 Mar 2022 17:44:48 GMT

The error message does not mention that you can use a variable, so you can't use a variable.