What is the problem with the below code?
data test;
set address;
select(street_type);
when ( 'RI' ) street_type = 'RISE';
when ( 'LA' ) street_type = 'LANE';
when ( 'BLV') street_type = 'BVD';
end;
run;
why is it giving the below error ?
ERROR: Unsatisfied WHEN clause and no OTHERWISE clause at line 5 column 1.
You are checking for 3 values. What action to do if there is another value - this action should be written as OTHERWISE staement:
data test;
set address;
select(street_type);
when ( 'RI' ) street_type = 'RISE';
when ( 'LA' ) street_type = 'LANE';
when ( 'BLV') street_type = 'BVD';
otherwise street_type='****'; /* or any other value */
end;
run;
You are checking for 3 values. What action to do if there is another value - this action should be written as OTHERWISE staement:
data test;
set address;
select(street_type);
when ( 'RI' ) street_type = 'RISE';
when ( 'LA' ) street_type = 'LANE';
when ( 'BLV') street_type = 'BVD';
otherwise street_type='****'; /* or any other value */
end;
run;
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.