topic Re: Case statement multiple conditions in New SAS User

Case statement multiple conditions

MichaelC02 — Wed, 07 Jul 2021 00:02:50 GMT

I ran the below to create a computed column and everything worked fine. I then tried to edit this same code in working with data in different data set requiring multiple conditions to be met - meaning when x =1 and y = 1 and z = 1 and aa = 1, then the computed column "Work" but having trouble. How to I use AND for multiple conditions on different data columns? I'm working in SAS EG 7.1

case when XXX_ALL_DIM.lif_IND = 1 then 'Yes'

when YYY_ALL_DIM.lif_IND = 2 then 'No'

when ZZZ_ALL_DIM.lif_IND = 3 then 'Maybe'

else 'Other'

end

Re: Case statement multiple conditions

japelin — Wed, 07 Jul 2021 01:28:03 GMT

Please be a little more specific in presenting the code that works fine, the code that caused the trouble, and what the problem is.

Re: Case statement multiple conditions

SASKiwi — Wed, 07 Jul 2021 01:40:34 GMT

A good starting point would be to explicitly store the results of your CASE expression in a column:

case when XXX_ALL_DIM.lif_IND = 1 then 'Yes'
         when YYY_ALL_DIM.lif_IND = 2 then 'No'
         when ZZZ_ALL_DIM.lif_IND = 3 then 'Maybe'
         else 'Other'
end as MyCategory

Re: Case statement multiple conditions

MichaelC02 — Wed, 07 Jul 2021 02:49:18 GMT

This is the code I created for a new column and it worked just fine - but it's more of an If/Then. I'm now working with a different data set and I want to again create a new column that looks at 4 other columns from the data I'm querying and if each, all four of the columns, meets the criteria I have then I want the new column to reflect YES. Even if only one of the columns does does meet the criteria then Other, which would be NO.

case when BRWR_ALL_DIM.WIM_IND = 1 then 'PWM'

when BRWR_ALL_DIM.WIM_IND = 2 then 'WFA'

when BRWR_ALL_DIM.WIM_IND = 3 then 'WFA & PWM'

else 'Other'

end

Re: Case statement multiple conditions

SASKiwi — Wed, 07 Jul 2021 04:52:34 GMT

Yes, the query will work fine, but if you are creating a table and want the column created from the CASE expression to not have a default name then you need to specify what you actually want to call it as in my example.

Regarding using CASE with four input columns - yes that is perfectly feasible. Please post what you have tried so far as the example you have posted doesn't appear to be related to your question.

Re: Case statement multiple conditions

andreas_lds — Wed, 07 Jul 2021 06:15:55 GMT

Looks like a perfect task for a format.

proc fomat;
  value YesNoMaybe
    1 = 'Yes'
    2 = 'No'
    3 = 'Maybe'
    other = 'other'
  ;
run;

proc print data=have;
  format lif_IND YesNoMaybe.;
run;

Re: Case statement multiple conditions

Kurt_Bremser — Wed, 07 Jul 2021 07:22:13 GMT

case
  when x = 1 and y = 1 and z = 1 then 1
  else 0
end as a

You can use compound conditions in SQL like anywhere else.