Counting id_job combinations and exposed ids: Help please.

ak2011 — Tue, 19 Nov 2019 10:50:03 GMT

I would greatly appreciate if someone helps me with the code to count the number of id_job 
combinations for the merged dataset below: I have a total of 17 obs with 8 id_jobs: os1-1,os1-1 and os1-1
is 1 id-job combination;os1-2,os1-2,os1-2,os1-2 and os1-2 is another id-job combination,etc 
for a total of 8 id-job combinations. For cla_expo & bio-exp, 0=unexposed and 1=exposed. 
My task is to count the number of id-job exposed for cla and bio: For cla(idchem=99005),bio(idchem=990021):
For cla: number of id_job exposed is 5/8=62.5%, bio:3/8=37.5%

I tried proc freq idchem(not shown) but it didn't give me the right percentages. 
Could someone help me with the SAS code to compute the percent id_job exposed for cla and bio,please

Also for the id exposed : For cla(idchem=990005), % id exposed is 3/4 = 75%

Thanks very much.

 






data idnew1;
input id$ job idchem;
datalines;
os1 1 990005
os1 1 9900021
os1 1 211700
os1 2 211700
os1 2 9900021
os1 2 210701
os1 2 990005
os2 1 210701
os2 1 990005
os2 2 9900021
os2 3 210701
os2 3 990005
os3 3 210701
os3 1 211700
os4 1 210701
os4 1 990005
os4 1 211700
;
run;

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 data idnew1;

74 input id$ job idchem;

75 datalines;

NOTE: The data set WORK.IDNEW1 has 17 observations and 3 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.02 seconds

93 ;

94 run;

96 /* Cla-Exposure*/

97 data cla;

98 set idnew1;

99 if idchem=990005 then Cla_Exp=1; else Cla_Exp=0;

100 run;

NOTE: There were 17 observations read from the data set WORK.IDNEW1.

NOTE: The data set WORK.CLA has 17 observations and 4 variables.

NOTE: DATA statement used (Total process time):

real time 0.01 seconds

cpu time 0.01 seconds

101

102 proc print data=cla;

103 run;

NOTE: There were 17 observations read from the data set WORK.CLA.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.17 seconds

cpu time 0.18 seconds

104

105 /* Bio-Exposure*/

106 data bio;

107 set idnew1;

108 if idchem=9900021 then Bio_Exp=1; else Bio_Exp=0;

109 run;

NOTE: There were 17 observations read from the data set WORK.IDNEW1.

NOTE: The data set WORK.BIO has 17 observations and 4 variables.

NOTE: DATA statement used (Total process time):

real time 0.01 seconds

cpu time 0.01 seconds

110

111 proc print data=bio;

112 run;

NOTE: There were 17 observations read from the data set WORK.BIO.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.17 seconds

cpu time 0.17 seconds

113

114 /* Merging cla & bio files*/

115 data m1; merge cla bio;

116 run;

NOTE: There were 17 observations read from the data set WORK.CLA.

NOTE: There were 17 observations read from the data set WORK.BIO.

NOTE: The data set WORK.M1 has 17 observations and 5 variables.

NOTE: DATA statement used (Total process time):

real time 0.01 seconds

cpu time 0.02 seconds

117

118 proc print data=m1;

119 Title"Merged Cla & Bio exposures";

120 run;

NOTE: There were 17 observations read from the data set WORK.M1.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.18 seconds

cpu time 0.18 seconds

121

122

123

124 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

136

Obs id job idchem Cla_Exp1234567891011121314151617

os1	1	990005	1
os1	1	9900021	0
os1	1	211700	0
os1	2	211700	0
os1	2	9900021	0
os1	2	210701	0
os1	2	990005	1
os2	1	210701	0
os2	1	990005	1
os2	2	9900021	0
os2	3	210701	0
os2	3	990005	1
os3	3	210701	0
os3	1	211700	0
os4	1	210701	0
os4	1	990005	1
os4	1	211700	0

Obs id job idchem Bio_Exp1234567891011121314151617

os1	1	990005	0
os1	1	9900021	1
os1	1	211700	0
os1	2	211700	0
os1	2	9900021	1
os1	2	210701	0
os1	2	990005	0
os2	1	210701	0
os2	1	990005	0
os2	2	9900021	1
os2	3	210701	0
os2	3	990005	0
os3	3	210701	0
os3	1	211700	0
os4	1	210701	0
os4	1	990005	0
os4	1	211700	0

Merged Cla & Bio exposures

Obs id job idchem Cla_Exp Bio_Exp1234567891011121314151617

os1	1	990005	1	0
os1	1	9900021	0	1
os1	1	211700	0	0
os1	2	211700	0	0
os1	2	9900021	0	1
os1	2	210701	0	0
os1	2	990005	1	0
os2	1	210701	0	0
os2	1	990005	1	0
os2	2	9900021	0	1
os2	3	210701	0	0
os2	3	990005	1	0
os3	3	210701	0	0
os3	1	211700	0	0
os4	1	210701	0	0
os4	1	990005	1	0
os4	1	211700	0	0

Re: Counting id_job combinations and exposed ids: Help please.

ak2011 — Tue, 19 Nov 2019 10:58:17 GMT

Please ignore this message. Is difficult to read the output. I will resend. Thanks.
ak

topic Counting id_job combinations and exposed ids: Help please. in SAS Studio

Counting id_job combinations and exposed ids: Help please.

Re: Counting id_job combinations and exposed ids: Help please.