what is wrong with this code?

[Dhana18]

data surrg.male_exposure2;
set surrg._male_exposure1;
if rect_exp = "1" OR rect_interc = "1" then rectal_exposure = "Yes";
else rectal_exposure = "0";
run;

[PaigeMiller]

Why do you think anything is wrong with it? Can you show us either the SASLOG, or results that are different than what you expect(and explain)?

[Dhana18]

260 data surrg.merged_male_exposure2;

261 set surrg.merged_male_exposure1;

262 if rect_exp = "1" OR rect_interc = "1" then rectal_exposure = "Yes";

263 run;

NOTE: There were 3439 observations read from the data set SURRG.MERGED_MALE_EXPOSURE1.

NOTE: The data set SURRG.MERGED_MALE_EXPOSURE2 has 3439 observations and 206 variables.

NOTE: DATA statement used (Total process time):

real time 0.50 seconds

cpu time 0.07 seconds

I did a frequency analysis of rect_exp there are 410 patients with that exposure and rect_interc has 263 patients and after this code there should be 473 rectal exposure but it only give me 425.  That is wrong.

[PaigeMiller]

Some patients have BOTH rect_exp='1' and rect_interc='1'

[ballardw · Accepted solution]

This should give you the overlapping conditions:

proc freq data=surrg.merged_male_exposure2;
  tables rect_exp* rect_interc* rectal_exposure /missing list ;
run;

[novinosrin]

syntactically my eyes can't notice anything

logically i don't know