cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
MichaelC02
‎09-27-2022
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Case statement multiple conditions

by Calcite | Level 5 in New SAS User
‎07-06-2021 10:49 PM
‎07-06-2021 10:49 PM
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 ... View more

Case statement multiple conditions

by Calcite | Level 5 in New SAS User
‎07-06-2021 08:02 PM
‎07-06-2021 08:02 PM
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 ... View more

Why am I not able to see all data elements?

by Calcite | Level 5 in New SAS User
‎02-05-2019 11:22 PM
‎02-05-2019 11:22 PM
I'm working w/SAS EG 7.4 and querying from a large data table with hundreds of data columns. Numerous times I've been unable to locate a specific data variable and yet a co-worker  - also using SAS EG - is able to open up table and find the variable. Are there limitations?   He mentioned something in regards to implicit / explicit pass through but I'm not well versed on the technical aspects.   Any assistance appreciated. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-27-2022 09:59 PM
Quick links