topic Re: Condense IF FIND in SAS Programming

Condense IF FIND

anonymous_user — Tue, 18 Oct 2016 13:30:17 GMT

Hi, how do I create an INLIST pn an IF FIND?

Re: Condense IF FIND

RW9 — Tue, 18 Oct 2016 12:50:37 GMT

What does posting_cat_2 look like. Post your test data in the form of a datastep so that we can see what you see and assess the best way to achieve this. If that variable just contains a, b, or c then:

select(posting_cat_2);

when ('a') ...

...

If it contains more, then what happens if more than one appear in the string? Is there a defining pattern which can identify these uniquely?

You may find it simpler to do a quick loop:

do i=1 to lengthn(posting_cat_2);
  if char(posting_cat_2,i) in ('a','b',...) then perf='3) >=...';
end;

Re: Condense IF FIND

anonymous_user — Tue, 18 Oct 2016 13:30:52 GMT

Re: Condense IF FIND

gamotte — Tue, 18 Oct 2016 12:59:49 GMT

Hello,

if prxmatch('/[a-j]\./',posting_cat2_new) then ...

Re: Condense IF FIND

Astounding — Tue, 18 Oct 2016 13:12:09 GMT

If your sample values are all left-hand justified, you can also use:

if posting_cat2_new in : ('a.', 'b.', 'c.', 'd.', 'g.', 'h.', 'k.', 'i.', 'j.') then ...

Re: Condense IF FIND

RW9 — Tue, 18 Oct 2016 13:18:38 GMT

Then the simplest way is:

if char(posting_cat_2,1) in ("a","b"...) then ...;

Re: Condense IF FIND

Kurt_Bremser — Tue, 18 Oct 2016 13:27:22 GMT

@RW9 wrote:

Then the simplest way is:

if char(posting_cat_2,1) in ("a","b"...) then ...;

if scan(posting_cat,1,'.') in ('a','b',...) then ...;

just for adding another option 😉

Re: Condense IF FIND

Haikuo — Tue, 18 Oct 2016 13:37:46 GMT

@gamotte wrote:

Hello,

if prxmatch('/[a-j]\./',posting_cat2_new) then ...

I like it. I would just tweak a little to make it more robust,

if prxmatch('/^[a-j]\./',left(posting_cat2_new)) then ...