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. ... View more

I use Sas EG and my proc sql have no errors. When I run it the first time, it generated output , then I made a few changes to the code like adding fields , in select and group by and when I run it, there is no error in log , and yet there is no output tab altogether! I am new to SAS and beginning to learn how it works. Please help. Thanks ... View more