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 (49.7%)

-0.2 (-1.2, 0.8) 0.703

-0.2 (-0.8, 0.3) 0.387

Female

400 (50.3%)

1.3 ( 0.5, 2.1) <0.001

0.5 ( 0.1, 0.9) 0.011

Education

Elementary or lower

327 (41.4%)

1.5 ( 0.5, 2.6) 0.004

0.6 ( 0.1, 1.2) 0.016

Middle school

249 (31.5%)

0.6 (-0.4, 1.6) 0.237

0.0 (-0.6, 0.6) 0.957

High school or above

214 (27.1%)

-0.5 ( -1.4, 0.5) 0.354

0.1 (-0.5, 0.7) 0.712

Occupation

Farmer

383 (48.5%)

-0.6 (-1.6, 0.3) 0.210

-0.3 (-0.9, 0.2) 0.199

Others

407 (51.5%)

1.5 ( 0.8, 2.3) <0.001

0.6 ( 0.2, 1.1) 0.002

Cigarette smoking

No

478 (60.7%)

0.8 ( 0.1, 1.4) 0.032

0.4 ( 0.0, 0.8) 0.038

Yes

310 (39.3%)

0.2 (-0.9, 1.4) 0.689

-0.1 (-0.7, 0.5) 0.761

Alcohol consumption

No

666 (84.9%)

0.6 ( 0.0, 1.3) 0.048

0.3 (-0.1, 0.6) 0.105

Yes

118 (15.1%)

0.4 (-1.6, 2.4) 0.669

-0.1 (-1.2, 1.0) 0.833

ß (95%CI) p-value / OR/RR (95%CI) p-value
Outcome: SBP and DBP
Risk factor: Body mass index
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.4, 4.3) 0.322

1.5 ( 0.4, 2.6) 0.008

1.5 ( 0.5, 2.6) 0.004

Middle school

0.1 (-1.6, 1.8) 0.873

1.0 ( 0.0, 1.9) 0.042

0.6 (-0.4, 1.6) 0.237

High school or above

-1.1 ( -2.2, 0.0) 0.056

1.7 (-0.5, 3.9) 0.132

-0.5 ( -1.4, 0.5) 0.354

Occupation

Farmer

-0.9 (-2.6, 0.8) 0.310

-0.1 (-1.0, 0.9) 0.913

-0.6 (-1.6, 0.3) 0.210

Others

0.4 (-0.7, 1.4) 0.494

2.3 ( 1.2, 3.4) <0.001

1.5 ( 0.8, 2.3) <0.001

Cigarette smoking

No

-0.3 (-1.7, 1.1) 0.663

1.3 ( 0.5, 2.1) 0.001

0.8 ( 0.1, 1.4) 0.032

Yes

0.0 (-1.3, 1.3) 0.992

1.5 ( -2.0, 5.0) 0.407

0.2 (-0.9, 1.4) 0.689

Alcohol consumption

No

-0.3 (-1.5, 0.8) 0.587

1.3 ( 0.5, 2.1) <0.001

0.6 ( 0.0, 1.3) 0.048

Yes

0.3 (-1.6, 2.3) 0.739

0.4 (-1.6, 2.4) 0.669

DBP

Education

Elementary or lower

0.6 (-0.8, 2.0) 0.430

0.6 ( 0.1, 1.2) 0.026

0.6 ( 0.1, 1.2) 0.016

Middle school

-0.2 (-1.2, 0.8) 0.630

0.1 (-0.5, 0.7) 0.667

0.0 (-0.6, 0.6) 0.957

High school or above

-0.5 (-1.1, 0.1) 0.111

1.0 (-0.4, 2.5) 0.181

0.1 (-0.5, 0.7) 0.712

Occupation

Farmer

-0.7 (-1.7, 0.2) 0.134

0.0 (-0.6, 0.5) 0.968

-0.3 (-0.9, 0.2) 0.199

Others

0.2 (-0.4, 0.7) 0.559

0.9 ( 0.3, 1.5) 0.002

0.6 ( 0.2, 1.1) 0.002

Cigarette smoking

No

0.2 (-0.7, 1.1) 0.634

0.5 ( 0.1, 0.9) 0.023

0.4 ( 0.0, 0.8) 0.038

Yes

-0.3 (-1.0, 0.3) 0.331

1.1 (-0.5, 2.7) 0.192

-0.1 (-0.7, 0.5) 0.761

Alcohol consumption

No

-0.2 (-0.9, 0.4) 0.484

0.5 ( 0.1, 0.9) 0.011

0.3 (-0.1, 0.6) 0.105

Yes

-0.2 (-1.3, 0.9) 0.723

-0.1 (-1.2, 1.0) 0.833

ß (95%CI) p-value / OR/RR (95%CI) p-value
Outcome: SBP and DBP
Risk factor: Body mass index
Adjust for: AGE
Total group analysis 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

Low

Middle

High

SBP

Education

Elementary or lower

0

0.4 (-6.0, 6.7) 0.909

6.4 ( 0.2, 12.6) 0.045

Middle school

0

0.3 ( -5.4, 6.0) 0.909

1.9 ( -3.9, 7.7) 0.522

High school or above

0

-4.3 ( -8.9, 0.4) 0.074

-4.0 ( -9.0, 1.0) 0.117

Occupation

Farmer

0

-5.0 (-10.0, -0.1) 0.047

-2.2 ( -7.1, 2.7) 0.380

Others

0

2.8 (-1.8, 7.5) 0.230

6.2 ( 1.5, 11.0) 0.011

Cigarette smoking

No

0

-1.9 ( -6.0, 2.3) 0.379

2.7 ( -1.3, 6.8) 0.187

Yes

0

-0.1 (-5.9, 5.7) 0.966

-0.3 (-6.5, 5.9) 0.920

Alcohol consumption

No

0

-0.8 ( -4.5, 2.9) 0.670

2.4 ( -1.3, 6.1) 0.201

Yes

0

-2.5 (-12.3, 7.2) 0.613

-1.5 (-11.3, 8.3) 0.767

DBP

Education

Elementary or lower

0

0.0 (-3.1, 3.1) 0.994

2.3 (-0.8, 5.4) 0.142

Middle school

0

-2.6 (-6.0, 0.8) 0.135

-0.9 (-4.3, 2.6) 0.622

High school or above

0

-0.2 (-3.0, 2.6) 0.911

-2.2 (-5.2, 0.8) 0.161

Occupation

Farmer

0

-2.6 (-5.4, 0.1) 0.064

-2.3 (-5.0, 0.5) 0.104

Others

0

0.4 (-2.0, 2.9) 0.725

2.4 (-0.1, 4.9) 0.064

Cigarette smoking

No

0

-1.1 (-3.4, 1.2) 0.333

0.9 (-1.3, 3.1) 0.429

Yes

0

-0.5 (-3.5, 2.6) 0.765

-1.6 (-4.8, 1.7) 0.347

Alcohol consumption

No

0

-1.1 (-3.1, 0.8) 0.266

0.4 (-1.6, 2.4) 0.693

Yes

0

0.6 ( -4.7, 5.9) 0.813

-2.1 ( -7.5, 3.2) 0.433

ß (95%CI) p-value / OR/RR (95%CI) p-value
Outcome: SBP and DBP
Risk factor: Body mass index tertiles
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)