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
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
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
As @Reeza informed like cannot be used in datastep and showed how to get the same in datastep
below is example for same.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.