Combining multiple variables to create a new variable

[aigiss]

Hello everyone this is what I am dealing with. 

aigiss_0-1675370790769.png

I have three variables Syphilis Gonorrhea chlamydia (dichotomous) in dataset called "combined_dataset." I want to combined those variables to create a new variable "STIs" based on premise of 'N' and 'Y'. However, when I input the code (see below), the numbers are not adding up for the variable 'STIs' for 'Y' observations (should be n=1193). Can someone help? 

data combined_dataset;
  set combined_dataset;
  length STIs $1;
  if Syphilis = "Y" or Gonorrhea = "Y" or Chlamydia = "Y" then STIs = "Y";
  else combined_variable = "N";
run;

aigiss_1-1675370977915.png

[Reeza]

It should not be 1193 because it's not a mutually exclusive criteria. If they don't have chlamydia it doesn't mean they don't have something else at all.

[aigiss]

I fail to understand your explanation, I apologize can you clarify your answer? 

[Reeza · Accepted solution]

A person can have more than one disease at a time, so the most that Y should be is 1,193 but not what it should be. If you have more than one disease, you get counted only once in this summary.

[aigiss]

Ooooh. That is right. Duh! Thank you for the explanation. I need my cup of coffee. 

[Reeza]

No worries, I initially mixed up the Y/N in my explanation.