Filtering data

[Rou]

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]

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

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

[Rou]

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]

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