topic Re: How to parameterize a "Where statment" in a data set? ( SAS EG ) in New SAS User

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

victorlu — Wed, 13 Feb 2019 16:10:59 GMT

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"

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

Reeza — Wed, 13 Feb 2019 16:14:34 GMT

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.

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

ballardw — Wed, 13 Feb 2019 16:25:00 GMT

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.

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

victorlu — Wed, 13 Feb 2019 16:29:05 GMT

that's exaclty what i want !

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