How to parameterize a "Where statment" in a data set? ( SAS EG )

[victorlu]

Let's say that I want to :


DATA data_name;

SET set_name;

WHERE CLIENTS IN ("SECTOR_1","SECTOR_2","SECTOR_3");

Run;

How can I parameterize ("SECTOR_1","SECTOR_2","SECTOR_3")? 

I would like to sometimes run it just for SECTOR_1 AND SECTOR_2, and sometimes just SECTOR_3, for example.
Is there a way to create a macrovariable with the condition? "CLIENTS IN MACROVARIABLE"

[Reeza · Accepted solution]

Create a macro variable with the list of items you want to select.

%let selection = "SECTOR_1", "SECTOR_2";

data want;
set have;

where clients in (&selection.);

run;

But I suspect this isn't actually what you want, so if that's true, you need to provide more details on what you do want.

[victorlu]

that's exaclty what i want !

Obviously i createad a analogous problem, but that should do it!

[ballardw]

Are you actually replacing the data set DATA_NAME, or what that  may represent, multiple times? That likely would not be needed as you can use a where statement in many procedures and a data set option where in others.