topic Re: Combining conditions in where clause in SAS Programming

Combining conditions in where clause

Ranjeeta — Wed, 06 Mar 2019 19:13:48 GMT

data test ;
set CR_CATHD;
where (Cath_SSPCIIND = 'Y' or Cath_ScheduledPCIIND = 'Y' or Cath_StagedPCIIND = 'Y')and FYEAR =2016 and RemovalReasonCD = 'PS' and AcceptanceHCPNumber=1302 ;
run;

Hello Can someone advise How I would write the step abve or if the step above is correct in order to achieve the following:

I want the count of cases where either of the conditions in the parentheses is Y and the conditions outside the parentheses are satisfied.

Re: Combining conditions in where clause

novinosrin — Wed, 06 Mar 2019 19:25:23 GMT


data test ;
set CR_CATHD;
array t(*) Cath_SSPCIIND Cath_ScheduledPCIIND Cath_StagedPCIIND;
if 'Y' in t and FYEAR =2016 and RemovalReasonCD = 'PS' and AcceptanceHCPNumber=1302
then count+1;
run;

Re: Combining conditions in where clause

Ranjeeta — Wed, 06 Mar 2019 19:30:48 GMT

Thankyou !!

Re: Combining conditions in where clause

Ranjeeta — Wed, 06 Mar 2019 19:44:58 GMT

data test ;
285 set CR_CATHD;
286 array t(3) Cath_SSPCIIND Cath_ScheduledPCIIND Cath_StagedPCIIND;
287 if 'Y' in t and FYEAR =2016 and RemovalReasonCD = 'PS' and AcceptanceHCPNumber=953
288 then count+1;
289 run;

NOTE: There were 433888 observations read from the data set WORK.CR_CATHD.
NOTE: The data set WORK.TEST has 433888 observations and 241 variables.
NOTE: DATA statement used (Total process time):
real time 5.42 seconds
cpu time 1.29 seconds

What could be the reason that none of the filters are getting applied e.g.. FYear =2016 or

Re: Combining conditions in where clause

ballardw — Wed, 06 Mar 2019 19:53:26 GMT

@Ranjeeta wrote:

data test ;
285 set CR_CATHD;
286 array t(3) Cath_SSPCIIND Cath_ScheduledPCIIND Cath_StagedPCIIND;
287 if 'Y' in t and FYEAR =2016 and RemovalReasonCD = 'PS' and AcceptanceHCPNumber=953
288 then count+1;
289 run;

NOTE: There were 433888 observations read from the data set WORK.CR_CATHD.
NOTE: The data set WORK.TEST has 433888 observations and 241 variables.
NOTE: DATA statement used (Total process time):
real time 5.42 seconds
cpu time 1.29 seconds

What could be the reason that none of the filters are getting applied e.g.. FYear =2016 or

What makes you think none of the filters are applied?

The example here does not have any OR comparisons so the only values kept are the ones where all of the values match the IF condition. Though 'Y' in t is problematic. The SAS IN operator requires a fixed list of values. if you want to search a string value for Y anywhere in a variable the correct approach would be: if index(t,'Y') > 0. The index function returns the position number of the found value in the string variable or returns 0 if not found.

Re: Combining conditions in where clause

novinosrin — Wed, 06 Mar 2019 19:54:32 GMT

Ok, I am basically not filtering. I am basically counting the number of cases that satisfy the condition.

Please do take a look at the count.

Well , I think this should help you better as you really seem to want filtered records


data test ;
set CR_CATHD;
array t(*) Cath_SSPCIIND Cath_ScheduledPCIIND Cath_StagedPCIIND;
if 'Y' in t and FYEAR =2016 and RemovalReasonCD = 'PS' and AcceptanceHCPNumber=1302;
run;

Thats a subsetting if

Initially I assumed you wanted a count