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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.