Hi,
I have some code that runs fine but when i add in the case statement on Proc SQL it 'falls over'. Can anyone please advise where I am going wrong with the complete statement?
PROC SQL;
create table work.red as
select
num,
month_date,
arrs,
remaining_months,
platform,
valuation,
Type,
count(*) as count,
avg (tv) ,
avg (bal),
case when
remaining_months <= 1 then 'End'
else if Remaining_months <= 12 then 'End OP'
else if arrs not in '1' then 'Ars' else 'Rege' end as Red_son
from
sun.sunny
where
platform = 'O'
and Arrs not in ('L4','L5','L6')
group by
num,
month_date
arrs
remaining_months
platform
valuation
Type
quit;
Try modifying case statement syntax in above.
case
when remaining_months <= 1 then 'End'
when Remaining_months <= 12 then 'End OP'
when arrs ne '1' then 'Ars'
else 'Rege' end as Red_son
Try modifying case statement syntax in above.
case
when remaining_months <= 1 then 'End'
when Remaining_months <= 12 then 'End OP'
when arrs ne '1' then 'Ars'
else 'Rege' end as Red_son
Hi,
you are mixing SAS syntax and SQL there:
case when remaining_months <= 1 then 'End'
when Remaining_months <= 12 then 'End OP'
when arrs not in '1' then 'Ars'
else 'Rege' end as Red_son
The syntax is:
case when [condition] then [result]
else [fallout response] end
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.