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?
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
reeza always beats me to the answer...
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.