Exercise 4:    Create table 2 “Univariate analysis”

·         This exercise will use demo2 project. If you have not started demo2 project, click here to follow exercise 1: start the new project demo2

·         This exercise will use new variables. Click here to follow through Exercise 2:  Create new variables, code and label variables, if you have not done so.

Objectives:

·         Create univariate analysis table 1

·         Create univariate analysis table 2

·         Create univariate analysis table 3

================================================================================================

 

Objective 1: To create following table:

Univariate analysis 1

Male

Female

Total

SBP

Body mass index

-0.2 (-1.2, 0.8) 0.703

1.3 ( 0.5, 2.1) <0.001

0.7 ( 0.1, 1.3) 0.031

Body mass index tertiles

Low

0

0

0

Middle

-1.1 ( -5.7, 3.6) 0.659

-0.7 (-5.6, 4.2) 0.773

-1.1 (-4.5, 2.4) 0.545

High

-1.6 ( -6.6, 3.4) 0.531

4.8 ( 0.1, 9.5) 0.045

1.6 (-1.8, 5.0) 0.366

Education

Elementary or lower

0

0

0

Middle school

4.6 (-1.4, 10.5) 0.133

-0.9 (-5.9, 4.1) 0.731

0.8 (-3.0, 4.5) 0.692

High school or above

3.3 (-3.1, 9.6) 0.312

3.2 (-3.6, 10.0) 0.360

2.1 (-2.3, 6.6) 0.343

Occupation

Farmer

0

0

0

Others

-1.0 ( -5.2, 3.2) 0.640

8.6 ( 4.8, 12.4) <0.001

4.8 ( 2.0, 7.5) <0.001

Cigarette smoking

No

0

0

0

Yes

-5.0 ( -9.5, -0.4) 0.034

-1.5 (-8.8, 5.8) 0.684

-4.5 ( -8.4, -0.7) 0.022

Alcohol consumption

No

0

0

0

Yes

-1.7 ( -6.1, 2.7) 0.455

2.0 (-20.2, 24.3) 0.859

-2.1 (-6.4, 2.2) 0.332

SNP marker I

AA

0

0

0

AB

8.3 ( 4.1, 12.6) <0.001

8.6 ( 4.5, 12.6) <0.001

8.4 ( 5.5, 11.4) <0.001

BB

11.9 ( 3.6, 20.2) 0.005

11.8 ( 1.6, 22.1) 0.024

11.9 ( 5.5, 18.4) <0.001

DBP

Body mass index

-0.2 (-0.8, 0.3) 0.387

0.5 ( 0.1, 0.9) 0.011

0.2 (-0.1, 0.5) 0.205

Body mass index tertiles

Low

0

0

0

Middle

-1.0 (-3.5, 1.6) 0.470

-0.8 (-3.4, 1.8) 0.566

-0.9 (-2.8, 0.9) 0.315

High

-2.2 (-5.0, 0.6) 0.119

1.7 (-0.8, 4.1) 0.189

-0.2 (-2.0, 1.7) 0.850

Education

Elementary or lower

0

0

0

Middle school

2.7 (-0.6, 6.0) 0.116

1.0 (-1.7, 3.6) 0.476

1.8 (-0.2, 3.8) 0.080

High school or above

1.8 (-1.7, 5.3) 0.313

5.1 ( 1.5, 8.6) 0.005

2.6 ( 0.2, 5.0) 0.031

Occupation

Farmer

0

0

0

Others

-0.3 (-2.6, 2.1) 0.828

2.7 ( 0.7, 4.7) 0.009

1.4 (-0.1, 2.9) 0.065

Cigarette smoking

No

0

0

0

Yes

-0.6 (-3.2, 1.9) 0.625

0.7 (-3.1, 4.5) 0.716

-0.4 (-2.4, 1.7) 0.733

Alcohol consumption

No

0

0

0

Yes

0.5 (-1.9, 3.0) 0.670

2.8 (-8.9, 14.4) 0.641

0.5 (-1.8, 2.8) 0.676

SNP marker I

AA

0

0

0

AB

2.8 ( 0.4, 5.2) 0.022

1.8 (-0.4, 4.0) 0.103

2.3 ( 0.7, 3.9) 0.005

BB

3.6 (-1.0, 8.3) 0.129

2.1 (-3.4, 7.6) 0.456

3.0 (-0.5, 6.5) 0.096

ß (95%CI) p-value / OR/RR (95%CI) p-value
Outcome: SBP and DBP
Adjust for: AGE
Stratified by: SEX
Total group analysis also adjusted for SEX

 

Follow following steps to create the above table:

·         Click “Advanced analysis” -> “Univariate analysis”

·         Drag and drop variable SBP and DBP to “Select outcome variables (Y)”

·         Drag and drop BMI, BMI3, EDUC, OCCU, SMK, ALH and SNP1 to “Select risk factors (X)”

·         Drag and drop AGE to “Select adjusting variables”.

·         Drag and drop SEX (or select it from drop down list) to “Select column stratified variable”

            

·         Click “View Table” button, wait for a few seconds, you will get the above table

 

Done!

 

Objective 2:  To create following table:

Univariate analysis 2

Statistics

SBP

DBP

Body mass index

21.2 + 2.3

0.7 ( 0.1, 1.3) 0.031

0.2 (-0.1, 0.5) 0.205

Body mass index tertiles

Low

263 (33.1%)

0

0

Middle

267 (33.6%)

-1.1 ( -4.5, 2.4) 0.545

-0.9 (-2.8, 0.9) 0.315

High

265 (33.3%)

1.6 ( -1.8, 5.0) 0.366

-0.2 (-2.0, 1.7) 0.850

Education

Elementary or lower

342 (41.4%)

0

0

Middle school

259 (31.3%)

0.8 (-3.0, 4.5) 0.692

1.8 (-0.2, 3.8) 0.080

High school or above

226 (27.3%)

2.1 (-2.3, 6.6) 0.343

2.6 ( 0.2, 5.0) 0.031

Occupation

Farmer

401 (48.5%)

0

0

Others

426 (51.5%)

4.8 ( 2.0, 7.5) <0.001

1.4 (-0.1, 2.9) 0.065

Cigarette smoking

No

496 (60.1%)

0

0

Yes

329 (39.9%)

-4.5 ( -8.4, -0.7) 0.022

-0.4 (-2.4, 1.7) 0.733

Alcohol consumption

No

693 (84.4%)

0

0

Yes

128 (15.6%)

-2.1 ( -6.4, 2.2) 0.332

0.5 (-1.8, 2.8) 0.676

SNP marker I

AA

509 (62.3%)

0

0

AB

270 (33.0%)

8.4 ( 5.5, 11.4) <0.001

2.3 ( 0.7, 3.9) 0.005

BB

38 ( 4.7%)

11.9 ( 5.5, 18.4) <0.001

3.0 (-0.5, 6.5) 0.096

ß (95%CI) p-value / OR/RR (95%CI) p-value
Outcome: SBP and DBP
Adjust for: AGE and SEX

Follow following input screen shot to create the above table

(Change from objective 1:  delete column stratified variable, add sex to adjusting variables)

 

Objective 3:  To create following table:

Adjusted mean of SBP and DBP

Statistics

SBP

DBP

Body mass index tertiles

Low

263 (33.1%)

130.1 (127.7, 132.6)

69.9 (68.5, 71.2)

Middle

267 (33.6%)

129.1 (126.7, 131.5)

68.9 (67.6, 70.2)

High

265 (33.3%)

131.7 (129.3, 134.1)

69.7 (68.4, 71.0)

P trend

0.363

0.853

Education

Elementary or lower

342 (41.4%)

129.5 (126.9, 132.0)

68.2 (66.9, 69.6)

Middle school

259 (31.3%)

130.2 (127.7, 132.8)

70.0 (68.7, 71.4) *

High school or above

226 (27.3%)

131.6 (128.6, 134.7)

70.9 (69.2, 72.5) **

P trend

0.342

0.031

Occupation

Farmer

401 (48.5%)

127.8 (125.8, 129.8)

68.8 (67.7, 69.9)

Others

426 (51.5%)

132.6 (130.7, 134.5) ***

70.2 (69.2, 71.2) *

P trend

<0.001

0.065

Cigarette smoking

No

496 (60.1%)

132.1 (130.0, 134.1)

69.7 (68.5, 70.8)

Yes

329 (39.9%)

127.6 (124.9, 130.3) **

69.3 (67.8, 70.8)

P trend

0.022

0.733

Alcohol consumption

No

693 (84.4%)

130.6 (129.0, 132.1)

69.4 (68.6, 70.3)

Yes

128 (15.6%)

128.4 (124.5, 132.3)

69.9 (67.8, 72.0)

P trend

0.332

0.676

SNP marker I

AA

509 (62.3%)

127.0 (125.3, 128.8)

68.6 (67.6, 69.5)

AB

270 (33.0%)

135.5 (133.1, 137.8) ***

70.9 (69.6, 72.2) ***

BB

38 ( 4.7%)

138.9 (132.7, 145.2) ***

71.6 (68.2, 75.0) *

P trend

<0.001

0.003

adjust means (95%CI) * P<0.1, ** P<0.05, *** P<0.01
Outcome: SBP and DBP
Adjust for: AGE and SEX

Follow following input screen shot to create the above table

(Change from objective 2:  change output format to “adjust mean (95%CI) *”)