Case statement error

[SAS241]

I get this error in this portion of my code:
proc sql;
Create table test as
…,
(Case when Brangen = ‘1’ then ‘Gen’
when Brangen = ‘2’ then ‘Bran’
when Brangen = ‘3’ then ‘Undet’ else ‘E’ end ) as Flag
,
….

The format of Brangen is character
How do I fix this error:
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.

[SASKiwi]

That is not a SAS ERROR, it is a SAS NOTE:

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.

Your program will continue to run OK. If you want to avoid these notes then just add an ELSE.

[SAS241]

There is already an Else in my code

[Kurt_Bremser]

Check all CASE expressions in your code. The SAS system does not issue this NOTE without cause.

[SASKiwi]

There must be an issue with your syntax then. Please post your complete SAS log if you want further help.

[Tom]

---

@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.