topic Re: what is wrong with this code? in SAS Programming

what is wrong with this code?

Dhana18 — Thu, 20 Sep 2018 18:30:31 GMT

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;

Re: what is wrong with this code?

PaigeMiller — Thu, 20 Sep 2018 18:31:59 GMT

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)?

Re: what is wrong with this code?

novinosrin — Thu, 20 Sep 2018 18:33:23 GMT

syntactically my eyes can't notice anything

logically i don't know

Re: what is wrong with this code?

Dhana18 — Thu, 20 Sep 2018 19:11:50 GMT

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.

Re: what is wrong with this code?

PaigeMiller — Thu, 20 Sep 2018 19:16:11 GMT

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

Re: what is wrong with this code?

ballardw — Thu, 20 Sep 2018 20:33:47 GMT

This should give you the overlapping conditions:

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