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

Variables

Male

Female

Total

SBP

Body mass inex

-0.2 (-1.2, 0.8) 0.702

1.3 (0.5, 2.1) <0.001

0.7 (0.1, 1.3) 0.030

Body mass inex tertiles

Low

0

0

0

Middle

-1.1 (-5.7, 3.6) 0.657

-0.7 (-5.6, 4.2) 0.772

-1.1 (-4.4, 2.3) 0.543

High

-1.6 (-6.6, 3.4) 0.529

4.8 (0.1, 9.5) 0.043

1.6 (-1.8, 5.0) 0.364

Education

Elementary or lower

0

0

0

Middle school

4.6 (-1.4, 10.5) 0.131

-0.9 (-5.9, 4.1) 0.730

0.8 (-3.0, 4.5) 0.690

High school or above

3.3 (-3.0, 9.6) 0.309

3.2 (-3.6, 9.9) 0.357

2.1 (-2.3, 6.6) 0.341

Occupation

Farmer

0

0

0

Others

-1.0 (-5.2, 3.2) 0.639

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.032

-1.5 (-8.8, 5.7) 0.683

-4.5 (-8.4, -0.7) 0.021

Alcohol consumption

No

0

0

0

Yes

-1.7 (-6.1, 2.7) 0.452

2.0 (-20.2, 24.2) 0.858

-2.1 (-6.4, 2.2) 0.331

SNP marker I

AA

0

0

0

AB

8.3 (4.1, 12.5) <0.001

8.6 (4.6, 12.6) <0.001

8.4 (5.5, 11.4) <0.001

BB

11.9 (3.7, 20.2) 0.005

11.8 (1.6, 22.0) 0.023

11.9 (5.5, 18.3) <0.001

DBP

Body mass inex

-0.2 (-0.8, 0.3) 0.385

0.5 (0.1, 0.9) 0.010

0.2 (-0.1, 0.5) 0.203

Body mass inex tertiles

Low

0

0

0

Middle

-1.0 (-3.5, 1.6) 0.468

-0.8 (-3.3, 1.8) 0.563

-0.9 (-2.8, 0.9) 0.313

High

-2.2 (-5.0, 0.5) 0.116

1.7 (-0.8, 4.1) 0.186

-0.2 (-2.0, 1.7) 0.849

Education

Elementary or lower

0

0

0

Middle school

2.7 (-0.6, 5.9) 0.113

1.0 (-1.6, 3.6) 0.473

1.8 (-0.2, 3.8) 0.078

High school or above

1.8 (-1.7, 5.3) 0.310

5.1 (1.5, 8.6) 0.005

2.6 (0.2, 5.0) 0.030

Occupation

Farmer

0

0

0

Others

-0.3 (-2.6, 2.1) 0.827

2.7 (0.7, 4.7) 0.009

1.4 (-0.1, 2.9) 0.064

Cigarette smoking

No

0

0

0

Yes

-0.6 (-3.2, 1.9) 0.624

0.7 (-3.1, 4.5) 0.715

-0.4 (-2.4, 1.7) 0.732

Alcohol consumption

No

0

0

0

Yes

0.5 (-1.9, 3.0) 0.668

2.8 (-8.8, 14.4) 0.640

0.5 (-1.8, 2.8) 0.675

SNP marker I

AA

0

0

0

AB

2.8 (0.4, 5.2) 0.021

1.8 (-0.4, 4.0) 0.101

2.3 (0.7, 3.9) 0.005

BB

3.6 (-1.0, 8.3) 0.126

2.1 (-3.4, 7.6) 0.454

3.0 (-0.5, 6.5) 0.094

 

ß(95%CI) p-value or OR/RR(95%CI) p-value

Outcome: SBP and DBP

All models adjust for AGE

Pooled analysis were 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

Variables

Statistics

SBP

DBP

Body mass inex

795 (21.2 ± 2.3)

0.7 (0.1, 1.3) 0.030

0.2 (-0.1, 0.5) 0.203

Body mass inex tertiles

Low

263 (33.1%)

0

0

Middle

267 (33.6%)

-1.1 (-4.4, 2.3) 0.543

-0.9 (-2.8, 0.9) 0.313

High

265 (33.3%)

1.6 (-1.8, 5.0) 0.364

-0.2 (-2.0, 1.7) 0.849

Education

Elementary or lower

342 (41.4%)

0

0

Middle school

259 (31.3%)

0.8 (-3.0, 4.5) 0.690

1.8 (-0.2, 3.8) 0.078

High school or above

226 (27.3%)

2.1 (-2.3, 6.6) 0.341

2.6 (0.2, 5.0) 0.030

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.064

Cigarette smoking

No

496 (60.1%)

0

0

Yes

329 (39.9%)

-4.5 (-8.4, -0.7) 0.021

-0.4 (-2.4, 1.7) 0.732

Alcohol consumption

No

693 (84.4%)

0

0

Yes

128 (15.6%)

-2.1 (-6.4, 2.2) 0.331

0.5 (-1.8, 2.8) 0.675

SNP marker I

AA

509 (62.3%)

0

0

AB

270 (33%)

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.3) <0.001

3.0 (-0.5, 6.5) 0.094

 

ß(95%CI) p-value or OR/RR(95%CI) p-value

Outcome: SBP and DBP

All models 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

Variables

Statistics

SBP

DBP

Body mass inex tertiles

Low

263 (33.1%)

130.1 (127.7, 132.5)

69.9 (68.6, 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.362

0.853

Education

Elementary or lower

342 (41.4%)

129.4 (126.9, 132.0)

68.2 (66.9, 69.6)

Middle school

259 (31.3%)

130.2 (127.7, 132.7)

70.0 (68.7, 71.4)*

High school or above

226 (27.3%)

131.6 (128.5, 134.6)

70.8 (69.2, 72.5)*

p(trend)

0.341

0.031

Occupation

Farmer

401 (48.5%)

127.8 (125.8, 129.8)

68.8 (67.7, 69.8)

Others

426 (51.5%)

132.6 (130.6, 134.5)*

70.2 (69.1, 71.2)*

p(trend)

0.001

0.064

Cigarette smoking

No

496 (60.1%)

132.0 (130.0, 134.1)

69.6 (68.5, 70.8)

Yes

329 (39.9%)

127.5 (124.8, 130.2)*

69.3 (67.8, 70.7)

p(trend)

0.021

0.732

Alcohol consumption

No

693 (84.4%)

130.5 (128.9, 132.0)

69.4 (68.6, 70.2)

Yes

128 (15.6%)

128.4 (124.5, 132.2)

69.9 (67.8, 72.0)

p(trend)

0.331

0.675

SNP marker I

AA

509 (62.3%)

127.0 (125.3, 128.7)

68.5 (67.6, 69.5)

AB

270 (33%)

135.4 (133.0, 137.8)*

70.8 (69.5, 72.1)*

BB

38 (4.7%)

138.9 (132.7, 145.1)*

71.6 (68.2, 74.9)*

p(trend)

0.000

0.003

 

Outcome: SBP and DBP

All models 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) *”)