Desktop productivity for business analysts and programmers

Nested IF Conditions

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Nested IF Conditions

[ Edited ]

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

 


Accepted Solutions
Solution
‎01-11-2018 11:12 PM
Super User
Posts: 23,992

Re: Nested IF Conditions

[ Edited ]

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

 


 

View solution in original post


All Replies
Solution
‎01-11-2018 11:12 PM
Super User
Posts: 23,992

Re: Nested IF Conditions

[ Edited ]

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

 


 

PROC Star
Posts: 549

Re: Nested IF Conditions

 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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 442 views
  • 1 like
  • 3 in conversation