Exercise 5:    Create table 3 “Stratified 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 stratified analysis table 1

·         Create stratified analysis table 2

·         Create stratified analysis table 3

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

 

Objective 1: To create following table:

Stratified analysis 1

-

N

SBP

DBP

SEX

Male

395

-0.2 (-1.2, 0.8) 0.702

-0.2 (-0.8, 0.3) 0.385

Female

400

1.3 (0.5, 2.1) <0.001

0.5 (0.1, 0.9) 0.010

Education

Elementary or lower

327

1.5 (0.5, 2.6) 0.004

0.6 (0.1, 1.2) 0.015

Middle school

249

0.6 (-0.4, 1.6) 0.233

-0.0 (-0.6, 0.6) 0.957

High school or above

214

-0.5 (-1.4, 0.5) 0.349

0.1 (-0.5, 0.7) 0.709

Occupation

Farmer

383

-0.6 (-1.6, 0.3) 0.207

-0.3 (-0.9, 0.2) 0.196

Others

407

1.5 (0.8, 2.3) <0.001

0.6 (0.2, 1.0) 0.002

Cigarette smoking

No

478

0.8 (0.1, 1.4) 0.031

0.4 (0.0, 0.8) 0.036

Yes

310

0.2 (-0.9, 1.4) 0.688

-0.1 (-0.7, 0.5) 0.759

Alcohol consumption

No

666

0.6 (0.0, 1.3) 0.047

0.3 (-0.1, 0.6) 0.103

Yes

118

0.4 (-1.5, 2.4) 0.664

-0.1 (-1.2, 1.0) 0.830

 

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

Outcome: SBP and DBP

Risk factor: Body mass inex

All models adjust for AGE

Follow following steps to create the above table:

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

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

·         Drag and drop BMI to “Select risk factors(X)”

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

·         Drag and drop SEX, EDUC, OCCU, SMK and ALH to “Select stratified variables (Rows)”

            

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

 

Done!

 

Objective 2:  To create following table:

Stratified analysis 2

-

Male

Female

Total

SBP

Education

Elementary or lower

1.5 (-1.3, 4.2) 0.308

1.5 (0.4, 2.6) 0.007

1.5 (0.5, 2.6) 0.005

Middle school

0.1 (-1.5, 1.8) 0.871

1.0 (0.1, 1.9) 0.037

0.6 (-0.4, 1.6) 0.223

High school or above

-1.1 (-2.2, 0.0) 0.052

1.7 (-0.4, 3.8) 0.111

-0.4 (-1.3, 0.6) 0.474

Occupation

Farmer

-0.9 (-2.6, 0.8) 0.305

-0.1 (-1.0, 0.9) 0.913

-0.4 (-1.4, 0.5) 0.387

Others

0.4 (-0.7, 1.4) 0.490

2.3 (1.2, 3.3) <0.001

1.5 (0.8, 2.3) <0.001

Cigarette smoking

No

-0.3 (-1.7, 1.1) 0.658

1.3 (0.5, 2.0) 0.001

0.9 (0.2, 1.6) 0.008

Yes

-0.0 (-1.3, 1.3) 0.992

1.5 (-1.8, 4.8) 0.377

0.2 (-0.9, 1.4) 0.687

Alcohol consumption

No

-0.3 (-1.4, 0.8) 0.585

1.3 (0.5, 2.0) <0.001

0.8 (0.1, 1.4) 0.021

Yes

0.3 (-1.6, 2.3) 0.735

-221.1 (-236.6, -205.7) <0.001

0.4 (-1.5, 2.4) 0.673

DBP

Education

Elementary or lower

0.6 (-0.8, 2.0) 0.418

0.6 (0.1, 1.2) 0.024

0.6 (0.1, 1.1) 0.020

Middle school

-0.2 (-1.2, 0.7) 0.626

0.1 (-0.5, 0.7) 0.661

-0.0 (-0.6, 0.6) 0.959

High school or above

-0.5 (-1.1, 0.1) 0.106

1.0 (-0.4, 2.4) 0.158

0.0 (-0.6, 0.6) 0.958

Occupation

Farmer

-0.7 (-1.7, 0.2) 0.130

-0.0 (-0.6, 0.5) 0.968

-0.3 (-0.9, 0.2) 0.224

Others

0.2 (-0.4, 0.7) 0.556

0.9 (0.3, 1.5) 0.002

0.6 (0.2, 1.0) 0.003

Cigarette smoking

No

0.2 (-0.7, 1.1) 0.629

0.5 (0.1, 0.9) 0.022

0.4 (0.0, 0.8) 0.030

Yes

-0.3 (-1.0, 0.3) 0.328

1.1 (-0.4, 2.6) 0.160

-0.1 (-0.7, 0.5) 0.744

Alcohol consumption

No

-0.2 (-0.9, 0.4) 0.481

0.5 (0.1, 0.9) 0.010

0.3 (-0.1, 0.6) 0.108

Yes

-0.2 (-1.3, 0.9) 0.719

18.7 (3.2, 34.1) 0.018

-0.1 (-1.2, 0.9) 0.808

 

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

Outcome: SBP and DBP

Risk factor: Body mass inex

All models adjust for AGE

Pooled analysis were also adjusted for SEX

 

Follow following input screen shot to create the above table

(Change from objective 1:  delete SEX from “Select stratified variables (Rows)” and add SEX to “Select column stratified variable”)

 

Objective 3:  To create following table:

Stratified analysis 3

-

Low

Middle

High

SBP

Education

Elementary or lower

0

0.4 (-5.9, 6.7) 0.908

6.4 (0.2, 12.5) 0.043

Middle school

0

0.3 (-5.3, 6.0) 0.908

1.9 (-3.8, 7.6) 0.517

High school or above

0

-4.3 (-8.8, 0.3) 0.069

-4.0 (-8.9, 0.9) 0.111

Occupation

Farmer

0

-5.0 (-9.9, -0.1) 0.044

-2.2 (-7.1, 2.7) 0.376

Others

0

2.8 (-1.8, 7.4) 0.227

6.2 (1.5, 11.0) 0.010

Cigarette smoking

No

0

-1.9 (-6.0, 2.3) 0.376

2.7 (-1.3, 6.8) 0.184

Yes

0

-0.1 (-5.9, 5.6) 0.965

-0.3 (-6.5, 5.8) 0.919

Alcohol consumption

No

0

-0.8 (-4.4, 2.9) 0.669

2.4 (-1.3, 6.1) 0.199

Yes

0

-2.5 (-12.1, 7.0) 0.604

-1.5 (-11.1, 8.1) 0.761

DBP

Education

Elementary or lower

0

0.0 (-3.1, 3.1) 0.994

2.3 (-0.7, 5.3) 0.138

Middle school

0

-2.6 (-6.0, 0.8) 0.130

-0.9 (-4.3, 2.5) 0.618

High school or above

0

-0.2 (-2.9, 2.6) 0.910

-2.2 (-5.1, 0.8) 0.154

Occupation

Farmer

0

-2.6 (-5.3, 0.1) 0.061

-2.3 (-5.0, 0.4) 0.100

Others

0

0.4 (-2.0, 2.9) 0.724

2.4 (-0.1, 4.9) 0.062

Cigarette smoking

No

0

-1.1 (-3.4, 1.1) 0.330

0.9 (-1.3, 3.1) 0.426

Yes

0

-0.5 (-3.5, 2.6) 0.763

-1.6 (-4.8, 1.7) 0.342

Alcohol consumption

No

0

-1.1 (-3.1, 0.8) 0.264

0.4 (-1.6, 2.4) 0.692

Yes

0

0.6 (-4.5, 5.8) 0.809

-2.1 (-7.4, 3.1) 0.422

 

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

Outcome: SBP and DBP

Risk factor: Body mass inex tertiles

All models adjust for AGE and SEX

 

Follow following input screen shot to create the above table

(Change from objective 2:  delete SEX from column stratified variable, add SEX to adjusting variables, change risk factors (X) to BMI3)