topic Re: sas select statement in SAS Programming

sas select statement

sfffdg — Fri, 22 Oct 2021 06:04:21 GMT

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.

Re: sas select statement

Shmuel — Fri, 22 Oct 2021 07:19:55 GMT

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;