Why doesn't my case work?

Reply
N/A
Posts: 1

Why doesn't my case work?

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

Regular Contributor
Posts: 168

Re: Why doesn't my case work?

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

Base SAS(R) 9.2 Procedures Guide

Super User
Super User
Posts: 7,430

Re: Why doesn't my case work?

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.

Ask a Question
Discussion stats
  • 2 replies
  • 150 views
  • 0 likes
  • 3 in conversation