topic Re: Case statement error in SAS Programming

Case statement error

SAS241 — Thu, 21 Nov 2024 18:53:52 GMT

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.

Re: Case statement error

SASKiwi — Thu, 21 Nov 2024 19:06:06 GMT

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.

Re: Case statement error

SAS241 — Thu, 21 Nov 2024 19:08:03 GMT

There is already an Else in my code

Re: Case statement error

Kurt_Bremser — Thu, 21 Nov 2024 19:14:30 GMT

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

Re: Case statement error

SASKiwi — Thu, 21 Nov 2024 19:53:03 GMT

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

Re: Case statement error

Tom — Fri, 22 Nov 2024 14:18:27 GMT

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