topic Re: Nested IF Conditions in SAS Enterprise Guide

Nested IF Conditions

J_T1 — Fri, 12 Jan 2018 01:32:33 GMT

Hi all,

I'm having trouble figuring out the syntax for a nested (or multiway) IF function is SAS EG

I have two conditions I want to meet before I assign a new value to a column.

eg.

data out;

set in;

IF state = 'qld' AND city LIKE 'bne%'

then column_one = 'OK'

run;

Any help greatly appreciated!

Thank you

Re: Nested IF Conditions

Reeza — Fri, 12 Jan 2018 02:11:51 GMT

city LIKE 'bne%'

Like isn't valid in data steps. Since it looks like you're checking for text that starts with 'bne' you can either try

city =: 'bne'

Or you could extract the first three characters using SUBSTR() and check if it equals bne.

@J_T1 wrote:

Hi all,

I'm having trouble figuring out the syntax for a nested (or multiway) IF function is SAS EG

I have two conditions I want to meet before I assign a new value to a column.

eg.

data out;

set in;

IF state = 'qld' AND city LIKE 'bne%'

then column_one = 'OK'

run;

Any help greatly appreciated!

Thank you

Re: Nested IF Conditions

kiranv_ — Fri, 12 Jan 2018 03:10:44 GMT

As @Reeza informed like cannot be used in datastep and showed how to get the same in datastep

below is example for same.

http://support.sas.com/kb/43/303.html