topic Re: Why doesn't my case work? in SAS Programming

Why doesn't my case work?

Azuki — Tue, 18 Nov 2014 08:57:54 GMT

case when t1.Points_To_Maintain > 500 then ''

when t1.Points_To_Maintain >=400 then '500'

when t1.Points_To_Maintain >=300 then '400'

when t1.Points_To_Maintain >=200 then '300'

when t1.Points_To_Maintain >=100 then '200'

else '100'

end

Re: Why doesn't my case work?

RamKumar — Tue, 18 Nov 2014 09:09:35 GMT

You need to give the variable name in end statement like 'end as points'. See example below

Base SAS(R) 9.2 Procedures Guide

Re: Why doesn't my case work?

RW9 — Tue, 18 Nov 2014 09:37:01 GMT

Post your full code, this snippet is not enough to see why "your case doesn't work", I quote that as you also have not mentioned "what does not work". Test data is also advisable.