topic Re: request to know how many and or can be used with in a single if clause in SAS Procedures

request to know how many and or can be used with in a single if clause

ssas — Tue, 17 Mar 2009 15:00:16 GMT

Hi,
i would like to know how many and 's or's we can use in a data step.
for example

data test1 test2 test3;
set soruce;
if type='a' or type= 'b3' or or type='a21' ................ then output test1;

/* loke wise how many or 's can i use with in a single if clause */

run;

thanks in advance

sams Message was edited by: sams1

Re: request to know how many and or can be used with in a single if clause

deleted_user — Tue, 17 Mar 2009 15:11:03 GMT

Hi,

The answer is pretty much as many as you could possibily hope to use. No doubt there is a limit but I've never reached it. If you have a number of ORs or ANDs which gets anywhere near the limit I would suggest you need to code you data step differently.

I would however suggest, in the example you give, using the IN operator.

e.g.

if type in ('a' 'b3' 'a21') then output test1;

Hope that helps.

Re: request to know how many and or can be used with in a single if clause

Bill — Tue, 17 Mar 2009 15:13:16 GMT

most probably quite a few ...

To reduce typing, consider

if type in ('a', 'a21', 'b3') then ...

Re: request to know how many and or can be used with in a single if clause

ssas — Thu, 19 Mar 2009 08:43:51 GMT

Excellent, many thanks for both of you.
My mind didn't striked about in operator.

Thanks for u r help