topic Re: Filtering data in SAS Programming

Filtering data

Rou — Sat, 04 Mar 2023 05:39:07 GMT

Hi all,

I am trying to create a new variable for patients who received neither treatment in my data. In total, 385 patients did not receive any drug.

Here is a sample code(it is wrong), and I need help. Thank you!

/*Creating a new variable for nontreatment*/
Data new;
set have;
if advil_dose= 0 then notreatment= 1 and if motrin_dose= 0 then notreatment= 2;
run;

Kurt_Bremser — Sat, 04 Mar 2023 06:27:45 GMT

If you want to count the number of not taken drugs, do this:

notreatment = (advil_dose = 0) + (motrin_dose = 0);

Rou — Sat, 04 Mar 2023 07:00:01 GMT

Thanks for your response, Kurt. I am not looking for a count of the no-drug subgroup instead, I want to create a new variable called notreatment.

If advil_dose = 0 then notreatment = 1 and if motrin_dose = 0 then no treatment= 2. I am not sure how to do this correctly in SAS.

Kurt_Bremser — Sat, 04 Mar 2023 07:11:54 GMT

What if both are zero? Which one should take precedence?