topic Re: case when in SAS Programming

case when

Christien — Thu, 20 Mar 2014 17:09:00 GMT

I have the next code:

"case when t1.AGB_instelling = '1.06' then Key_spec='03.05'

when t1.AGB_instelling = '1.07' then Key_spec='03.06'

end

For eacht AGB_instelling there are N Key_spec, for the two mentioned AGB_inst. I want the mentioned Key_spec but for other AGB_instellingen I don't care. But in the results I only found the two mentioned AGB_instellingen and no other. How can this be solved?

Re: case when

Reeza — Thu, 20 Mar 2014 17:19:45 GMT

Else.

case when t1.AGB_instelling = '1.06' then Key_spec='03.05'

when t1.AGB_instelling = '1.07' then Key_spec='03.06'

else key_spec="dont care"

end

Re: case when

DBailey — Thu, 20 Mar 2014 17:20:51 GMT

you should use the else clause to specify what should happen.

case

when t1.AGB_instelling = '1.06' then Key_spec='03.05'

when t1.AGB_instelling = '1.07' then Key_spec='03.06'

else ????

end

Re: case when

DBailey — Thu, 20 Mar 2014 17:21:11 GMT

reeza always beats me to the answer...