@SAS241 wrote: There is already an Else in my code
So either the ELSE is missing in a different CASE clause in your current query.
Or your current query is exercising a VIEW that has the incomplete CASE clause. Example:
2634 proc sql;
2635 create view v1 as
2636 select *,case when sex='M' then 'Male' when sex='F' then 'Female' end as gender
2637 from sashelp.class
2638 ;
NOTE: SQL view WORK.V1 has been defined.
2639 select name,sex,gender from v1;
NOTE: A CASE expression has no ELSE clause. Cases not accounted for by the WHEN clauses will result in a missing value for the CASE
expression.
... View more
