Nested IF Conditions

[J_T1]

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

[Reeza · Accepted solution]

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

---

[kiranv_]

 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