using Where and Keep in a set statement

tanya_henderson — Wed, 21 Mar 2018 12:32:25 GMT

I am trying to determine if I can combine a keep and a where in a set statement.

data sf;
set screen (where=(sf_flag='Y') keep = ( cno patno sf_flag) );
run;

Re: using Where and Keep in a set statement

Kurt_Bremser — Wed, 21 Mar 2018 13:06:59 GMT

Yes, that's perfectly possible. I'd just change the order of the two dataset options, as SAS executes the keep first and the where later.

In a dataset option, you can only apply the where to variables that are kept, as apposed to SQL, where you can set a where condition with variables not included in the select.

If you also use a rename= option, the order should be

keep=

rename=

where=

as that is the order in which SAS executes the option, so that the code as written represents the logical order.

topic Re: using Where and Keep in a set statement in SAS Programming

using Where and Keep in a set statement

Re: using Where and Keep in a set statement