topic Re: How to shorten multiple conditions with "or" ? in SAS Programming

How to shorten multiple conditions with "or" ?

Phil_NZ — Tue, 13 Apr 2021 06:04:14 GMT

Hi all,

Today I wrote this code

If (ccc > 365) or (s5> 365) or (s8>365) or (dpo >365) then delete;

I am wondering if there is any chance to shorten this code because 365 repeated many times.

Warm regards.

Re: How to shorten multiple conditions with "or" ?

Tom — Tue, 13 Apr 2021 06:10:43 GMT

For that condition to be true then at least one of those variables has to be larger then 365. Which means the max() of those variables has to be larger than 365.

If max(of ccc s5 s8) > 365 then delete;

Re: How to shorten multiple conditions with "or" ?

ChrisNZ — Tue, 13 Apr 2021 06:13:03 GMT

Like this?

if max(CCC,S5,S8,DPO)>365 then delete;