topic Re: Where and If Statements with multiple options in SAS Programming

Where and If Statements with multiple options

Schtroumpfette — Tue, 09 Feb 2021 21:52:15 GMT

Hello,

I have the code below and it works, but I would like to add options to "where" and "if" statements below and I keep getting errors.

Note: I already have a lowcase table.

I would also like to the add "emergency_patients" to "where" statement.

/*Identify Patient_Type_ID for in_patients and emergency_patients*/

title 'Proc Print patientid for in)patients';

proc print data=lib.hf_d_patient_type;

where patient_type CONTAINS 'in_patient';

run;

I would like to add another patient_id, "105" to the "if" statement.

/*Restrict Encounters to Inpatients Aged 18 Years or Above*/

data lib.dataB;

set mylib.dataA;

if patient_id=50;

run;

Thanks,

Schtroumfette!

Re: Where and If Statements with multiple options

Reeza — Tue, 09 Feb 2021 22:11:17 GMT

Depends on exactly what you're doing.

In this case (and the next) you can chain your conditions together with an OR

proc print data=lib.hf_d_patient_type;
where patient_type CONTAINS 'in_patient' 
          or patient_type contains 'emergency_patient';  
run;

There's also an IN operator, if you're looking for exact matches, which is why this approach does not work for the first WHERE statement.

data lib.dataB;

set mylib.dataA;

if patient_id in (50, 105) ;

run;

@Schtroumpfette wrote:

Hello,

I have the code below and it works, but I would like to add options to "where" and "if" statements below and I keep getting errors.

Note: I already have a lowcase table.

I would also like to the add "emergency_patients" to "where" statement.

/*Identify Patient_Type_ID for in_patients and emergency_patients*/

title 'Proc Print patientid for in)patients';

proc print data=lib.hf_d_patient_type;

where patient_type CONTAINS 'in_patient';

run;

I would like to add another patient_id, "105" to the "if" statement.

/*Restrict Encounters to Inpatients Aged 18 Years or Above*/

data lib.dataB;

set mylib.dataA;

if patient_id=50;

run;

Thanks,

Schtroumfette!

Re: Where and If Statements with multiple options

Schtroumpfette — Wed, 10 Feb 2021 00:11:12 GMT

Thank you Reeza,

The if statement worked, thanks.

The where statement did not work but that is fine. I run them separately and it worked and it was for a quality check.

Very helpful,
Thank you again,
Nisrine