Research-Oriented Questions Using Simulated MB Health Data 4 Question 1 - Check new variables 13:24 Thursday, August 19, 1999 Obs OP01 lensop lensop2 1 2751 0 0 2 8866 0 0 3 0 0 4 0 0 5 0 0 6 0 0 7 0 0 8 0 0 9 741 0 0 10 0 0 11 5300 0 0 12 0 0 13 1359 1 1 14 734 0 0 15 1319 1 1 16 595 0 0 17 1359 1 1 18 0 0 19 1359 1 1 20 7569 0 0 21 8683 0 0 22 0 0 23 0 0 24 3808 0 0 25 0 0 26 3722 0 0 27 2001 0 0 28 0 0 29 0 0 30 0 0 31 4442 0 0 32 3612 0 0 33 7906 0 0 34 0 0 35 8244 0 0 36 3328 0 0 37 0 0 38 0 0 39 4525 0 0 40 0 0 Research-Oriented Questions Using Simulated MB Health Data 5 Question 1 - mean age for lens vs no lens operation 13:24 Thursday, August 19, 1999 ------------------------------------------- lensop=0 ------------------------------------------- The MEANS Procedure Analysis Variable : AGE N Mean Std Dev Minimum Maximum -------------------------------------------------------------------- 4958 41.8021380 28.4065307 0 103.0000000 -------------------------------------------------------------------- ------------------------------------------- lensop=1 ------------------------------------------- Analysis Variable : AGE N Mean Std Dev Minimum Maximum -------------------------------------------------------------------- 42 75.1904762 12.4748295 21.0000000 97.0000000 -------------------------------------------------------------------- Research-Oriented Questions Using Simulated MB Health Data 6 Question 2 - Check new variable 13:24 Thursday, August 19, 1999 The FREQ Procedure Cumulative Cumulative DIAG01 DIAG02 Frequency Percent Frequency Percent --------------------------------------------------------------------- 4280 82009 1 2.13 1 2.13 82002 E8842 2 4.26 3 6.38 82002 E888 1 2.13 4 8.51 82002 E9289 1 2.13 5 10.64 82009 9581 1 2.13 6 12.77 82009 E8151 1 2.13 7 14.89 82009 E8842 2 4.26 9 19.15 82009 E885 3 6.38 12 25.53 82009 E8869 1 2.13 13 27.66 82009 E888 6 12.77 19 40.43 82021 80705 1 2.13 20 42.55 82021 E885 5 10.64 25 53.19 82021 E888 11 23.40 36 76.60 82022 E885 1 2.13 37 78.72 82022 E8860 1 2.13 38 80.85 82022 E888 2 4.26 40 85.11 8208 5990 1 2.13 41 87.23 8208 8730 1 2.13 42 89.36 8208 E8809 1 2.13 43 91.49 V5789 82021 2 4.26 45 95.74 V664 82009 1 2.13 46 97.87 V664 82021 1 2.13 47 100.00 Research-Oriented Questions Using Simulated MB Health Data 7 Question 2 - income by type of hospital 13:24 Thursday, August 19, 1999 The FREQ Procedure Table of INCDR by TYPEHSP INCDR TYPEHSP Frequency | Percent | Row Pct | Col Pct |1. WPG T|2. WPG N|3. OTHER| Total |EACHING |ON-TEACH| MANITOB| | | |A | ----------------+--------+--------+--------+ < $22,400 | 435 | 225 | 670 | 1330 | 9.26 | 4.79 | 14.26 | 28.31 | 32.71 | 16.92 | 50.38 | | 27.67 | 19.67 | 33.80 | ----------------+--------+--------+--------+ $22,400-$27,500 | 316 | 214 | 711 | 1241 | 6.73 | 4.56 | 15.13 | 26.42 | 25.46 | 17.24 | 57.29 | | 20.10 | 18.71 | 35.87 | ----------------+--------+--------+--------+ $27,600-$33,300 | 267 | 236 | 385 | 888 | 5.68 | 5.02 | 8.19 | 18.90 | 30.07 | 26.58 | 43.36 | | 16.98 | 20.63 | 19.42 | ----------------+--------+--------+--------+ $33,400-$41,200 | 282 | 257 | 139 | 678 | 6.00 | 5.47 | 2.96 | 14.43 | 41.59 | 37.91 | 20.50 | | 17.94 | 22.47 | 7.01 | ----------------+--------+--------+--------+ > $41,200 | 272 | 212 | 77 | 561 | 5.79 | 4.51 | 1.64 | 11.94 | 48.48 | 37.79 | 13.73 | | 17.30 | 18.53 | 3.88 | ----------------+--------+--------+--------+ Total 1572 1144 1982 4698 33.46 24.35 42.19 100.00 Frequency Missing = 302 Research-Oriented Questions Using Simulated MB Health Data 8 Question 3 - Hip fractures by transfers 13:24 Thursday, August 19, 1999 The FREQ Procedure Cumulative Cumulative TRANADM Frequency Percent Frequency Percent -------------------------------------------------------------------- 0. OTHER,NO TR. 26 55.32 26 55.32 1. TR.FROM HOSP 17 36.17 43 91.49 2. TR.FROM PCH 4 8.51 47 100.00 Cumulative Cumulative TRANDIS Frequency Percent Frequency Percent --------------------------------------------------------------------- 0. OTHER, NO TR. 18 38.30 18 38.30 1. TR.TO HOSP 20 42.55 38 80.85 2. TR.TO PCH 1 2.13 39 82.98 3. DIED 8 17.02 47 100.00 Research-Oriented Questions Using Simulated MB Health Data 9 Question 4 - 17 ICD-9-CM categories by CCI, by Gender 13:24 Thursday, August 19, 1999 The FREQ Procedure Table of ICD17BRK by CHARYES ICD17BRK CHARYES Frequency | Percent | Row Pct | Col Pct |00 |01 | Total -----------------+--------+--------+ 0 | 565 | 61 | 626 | 11.96 | 1.29 | 13.25 | 90.26 | 9.74 | | 15.01 | 6.35 | -----------------+--------+--------+ 1.INFECTIOUS/PAR | 49 | 3 | 52 ASITIC | 1.04 | 0.06 | 1.10 | 94.23 | 5.77 | | 1.30 | 0.31 | -----------------+--------+--------+ 2.NEOPLASMS | 51 | 257 | 308 | 1.08 | 5.44 | 6.52 | 16.56 | 83.44 | | 1.35 | 26.74 | -----------------+--------+--------+ 3.ENDOCRINE/NUTR | 24 | 52 | 76 /MET/IMM | 0.51 | 1.10 | 1.61 | 31.58 | 68.42 | | 0.64 | 5.41 | -----------------+--------+--------+ 4.BLOOD/BLOOD OR | 22 | 3 | 25 GANS | 0.47 | 0.06 | 0.53 | 88.00 | 12.00 | | 0.58 | 0.31 | -----------------+--------+--------+ 5.MENTAL DISORDE | 135 | 32 | 167 RS | 2.86 | 0.68 | 3.53 | 80.84 | 19.16 | | 3.59 | 3.33 | -----------------+--------+--------+ Total 3765 961 4726 79.67 20.33 100.00 (Continued) Research-Oriented Questions Using Simulated MB Health Data 10 Question 4 - 17 ICD-9-CM categories by CCI, by Gender 13:24 Thursday, August 19, 1999 The FREQ Procedure Table of ICD17BRK by CHARYES ICD17BRK CHARYES Frequency | Percent | Row Pct | Col Pct |00 |01 | Total -----------------+--------+--------+ 6.NERVOUS SYSTEM | 154 | 18 | 172 /SENSES | 3.26 | 0.38 | 3.64 | 89.53 | 10.47 | | 4.09 | 1.87 | -----------------+--------+--------+ 7.CIRCULATORY SY | 314 | 148 | 462 STEM | 6.64 | 3.13 | 9.78 | 67.97 | 32.03 | | 8.34 | 15.40 | -----------------+--------+--------+ 8.RESPIRATORY SY | 280 | 173 | 453 STEM | 5.92 | 3.66 | 9.59 | 61.81 | 38.19 | | 7.44 | 18.00 | -----------------+--------+--------+ 9.DIGESTIVE SYST | 431 | 67 | 498 EM | 9.12 | 1.42 | 10.54 | 86.55 | 13.45 | | 11.45 | 6.97 | -----------------+--------+--------+ 10.GENITOURINARY | 227 | 34 | 261 SYSTEM | 4.80 | 0.72 | 5.52 | 86.97 | 13.03 | | 6.03 | 3.54 | -----------------+--------+--------+ 11.COMPL.PREGNAN | 712 | 7 | 719 CY | 15.07 | 0.15 | 15.21 | 99.03 | 0.97 | | 18.91 | 0.73 | -----------------+--------+--------+ Total 3765 961 4726 79.67 20.33 100.00 (Continued) Research-Oriented Questions Using Simulated MB Health Data 11 Question 4 - 17 ICD-9-CM categories by CCI, by Gender 13:24 Thursday, August 19, 1999 The FREQ Procedure Table of ICD17BRK by CHARYES ICD17BRK CHARYES Frequency | Percent | Row Pct | Col Pct |00 |01 | Total -----------------+--------+--------+ 12.SKIN/SUBCUT | 45 | 14 | 59 | 0.95 | 0.30 | 1.25 | 76.27 | 23.73 | | 1.20 | 1.46 | -----------------+--------+--------+ 13.MUSCULOSKELET | 169 | 12 | 181 AL | 3.58 | 0.25 | 3.83 | 93.37 | 6.63 | | 4.49 | 1.25 | -----------------+--------+--------+ 14.CONGENITAL AN | 24 | 1 | 25 OMALIES | 0.51 | 0.02 | 0.53 | 96.00 | 4.00 | | 0.64 | 0.10 | -----------------+--------+--------+ 15.PERINATAL PER | 15 | 0 | 15 IOD | 0.32 | 0.00 | 0.32 | 100.00 | 0.00 | | 0.40 | 0.00 | -----------------+--------+--------+ 16.SYMPTOMS/SIGN | 217 | 32 | 249 S/ILL-DEF | 4.59 | 0.68 | 5.27 | 87.15 | 12.85 | | 5.76 | 3.33 | -----------------+--------+--------+ 17.INJURY/POISON | 331 | 47 | 378 ING | 7.00 | 0.99 | 8.00 | 87.57 | 12.43 | | 8.79 | 4.89 | -----------------+--------+--------+ Total 3765 961 4726 79.67 20.33 100.00 Frequency Missing = 274 Research-Oriented Questions Using Simulated MB Health Data 12 Question 4 - 17 ICD-9-CM categories by CCI, by Gender 13:24 Thursday, August 19, 1999 The FREQ Procedure Table of ICD17BRK by GENDER ICD17BRK GENDER Frequency | Percent | Row Pct | Col Pct |1. MALE |2. FEMAL| Total | |E | -----------------+--------+--------+ 0 | 318 | 348 | 666 | 6.36 | 6.96 | 13.32 | 47.75 | 52.25 | | 14.97 | 12.10 | -----------------+--------+--------+ 1.INFECTIOUS/PAR | 26 | 27 | 53 ASITIC | 0.52 | 0.54 | 1.06 | 49.06 | 50.94 | | 1.22 | 0.94 | -----------------+--------+--------+ 2.NEOPLASMS | 157 | 173 | 330 | 3.14 | 3.46 | 6.60 | 47.58 | 52.42 | | 7.39 | 6.02 | -----------------+--------+--------+ 3.ENDOCRINE/NUTR | 41 | 43 | 84 /MET/IMM | 0.82 | 0.86 | 1.68 | 48.81 | 51.19 | | 1.93 | 1.50 | -----------------+--------+--------+ 4.BLOOD/BLOOD OR | 9 | 19 | 28 GANS | 0.18 | 0.38 | 0.56 | 32.14 | 67.86 | | 0.42 | 0.66 | -----------------+--------+--------+ 5.MENTAL DISORDE | 77 | 113 | 190 RS | 1.54 | 2.26 | 3.80 | 40.53 | 59.47 | | 3.63 | 3.93 | -----------------+--------+--------+ Total 2124 2876 5000 42.48 57.52 100.00 (Continued) Research-Oriented Questions Using Simulated MB Health Data 13 Question 4 - 17 ICD-9-CM categories by CCI, by Gender 13:24 Thursday, August 19, 1999 The FREQ Procedure Table of ICD17BRK by GENDER ICD17BRK GENDER Frequency | Percent | Row Pct | Col Pct |1. MALE |2. FEMAL| Total | |E | -----------------+--------+--------+ 6.NERVOUS SYSTEM | 79 | 104 | 183 /SENSES | 1.58 | 2.08 | 3.66 | 43.17 | 56.83 | | 3.72 | 3.62 | -----------------+--------+--------+ 7.CIRCULATORY SY | 270 | 230 | 500 STEM | 5.40 | 4.60 | 10.00 | 54.00 | 46.00 | | 12.71 | 8.00 | -----------------+--------+--------+ 8.RESPIRATORY SY | 252 | 222 | 474 STEM | 5.04 | 4.44 | 9.48 | 53.16 | 46.84 | | 11.86 | 7.72 | -----------------+--------+--------+ 9.DIGESTIVE SYST | 268 | 249 | 517 EM | 5.36 | 4.98 | 10.34 | 51.84 | 48.16 | | 12.62 | 8.66 | -----------------+--------+--------+ 10.GENITOURINARY | 112 | 160 | 272 SYSTEM | 2.24 | 3.20 | 5.44 | 41.18 | 58.82 | | 5.27 | 5.56 | -----------------+--------+--------+ 11.COMPL.PREGNAN | 0 | 735 | 735 CY | 0.00 | 14.70 | 14.70 | 0.00 | 100.00 | | 0.00 | 25.56 | -----------------+--------+--------+ Total 2124 2876 5000 42.48 57.52 100.00 (Continued) Research-Oriented Questions Using Simulated MB Health Data 14 Question 4 - 17 ICD-9-CM categories by CCI, by Gender 13:24 Thursday, August 19, 1999 The FREQ Procedure Table of ICD17BRK by GENDER ICD17BRK GENDER Frequency | Percent | Row Pct | Col Pct |1. MALE |2. FEMAL| Total | |E | -----------------+--------+--------+ 12.SKIN/SUBCUT | 34 | 33 | 67 | 0.68 | 0.66 | 1.34 | 50.75 | 49.25 | | 1.60 | 1.15 | -----------------+--------+--------+ 13.MUSCULOSKELET | 84 | 106 | 190 AL | 1.68 | 2.12 | 3.80 | 44.21 | 55.79 | | 3.95 | 3.69 | -----------------+--------+--------+ 14.CONGENITAL AN | 19 | 6 | 25 OMALIES | 0.38 | 0.12 | 0.50 | 76.00 | 24.00 | | 0.89 | 0.21 | -----------------+--------+--------+ 15.PERINATAL PER | 10 | 5 | 15 IOD | 0.20 | 0.10 | 0.30 | 66.67 | 33.33 | | 0.47 | 0.17 | -----------------+--------+--------+ 16.SYMPTOMS/SIGN | 138 | 131 | 269 S/ILL-DEF | 2.76 | 2.62 | 5.38 | 51.30 | 48.70 | | 6.50 | 4.55 | -----------------+--------+--------+ 17.INJURY/POISON | 230 | 172 | 402 ING | 4.60 | 3.44 | 8.04 | 57.21 | 42.79 | | 10.83 | 5.98 | -----------------+--------+--------+ Total 2124 2876 5000 42.48 57.52 100.00 Research-Oriented Questions Using Simulated MB Health Data 15 Question 5 - Check new variables 13:24 Thursday, August 19, 1999 The FREQ Procedure Cumulative Cumulative DEATHSEP death90 deathall Frequency Percent Frequency Percent ------------------------------------------------------------------------------------ 0 1 1 166 3.32 166 3.32 1 1 1 3 0.06 169 3.38 2 1 1 3 0.06 172 3.44 3 1 1 1 0.02 173 3.46 4 1 1 1 0.02 174 3.48 5 1 1 2 0.04 176 3.52 6 1 1 3 0.06 179 3.58 7 1 1 4 0.08 183 3.66 8 1 1 1 0.02 184 3.68 9 1 1 2 0.04 186 3.72 10 1 1 2 0.04 188 3.76 11 1 1 4 0.08 192 3.84 12 1 1 5 0.10 197 3.94 13 1 1 4 0.08 201 4.02 14 1 1 1 0.02 202 4.04 15 1 1 3 0.06 205 4.10 16 1 1 3 0.06 208 4.16 17 1 1 2 0.04 210 4.20 18 1 1 2 0.04 212 4.24 19 1 1 1 0.02 213 4.26 20 1 1 2 0.04 215 4.30 22 1 1 1 0.02 216 4.32 23 1 1 4 0.08 220 4.40 24 1 1 3 0.06 223 4.46 25 1 1 2 0.04 225 4.50 26 1 1 1 0.02 226 4.52 28 1 1 3 0.06 229 4.58 29 1 1 2 0.04 231 4.62 30 1 1 4 0.08 235 4.70 33 1 1 1 0.02 236 4.72 34 1 1 2 0.04 238 4.76 35 1 1 3 0.06 241 4.82 37 1 1 1 0.02 242 4.84 38 1 1 1 0.02 243 4.86 40 1 1 1 0.02 244 4.88 41 1 1 3 0.06 247 4.94 42 1 1 2 0.04 249 4.98 43 1 1 2 0.04 251 5.02 44 1 1 2 0.04 253 5.06 45 1 1 1 0.02 254 5.08 46 1 1 1 0.02 255 5.10 47 1 1 2 0.04 257 5.14 48 1 1 2 0.04 259 5.18 49 1 1 3 0.06 262 5.24 50 1 1 2 0.04 264 5.28 53 1 1 1 0.02 265 5.30 Research-Oriented Questions Using Simulated MB Health Data 16 Question 5 - Check new variables 13:24 Thursday, August 19, 1999 The FREQ Procedure Cumulative Cumulative DEATHSEP death90 deathall Frequency Percent Frequency Percent ------------------------------------------------------------------------------------ 54 1 1 2 0.04 267 5.34 56 1 1 1 0.02 268 5.36 59 1 1 1 0.02 269 5.38 60 1 1 2 0.04 271 5.42 61 1 1 1 0.02 272 5.44 63 1 1 2 0.04 274 5.48 64 1 1 1 0.02 275 5.50 65 1 1 1 0.02 276 5.52 66 1 1 2 0.04 278 5.56 68 1 1 1 0.02 279 5.58 73 1 1 1 0.02 280 5.60 74 1 1 2 0.04 282 5.64 75 1 1 1 0.02 283 5.66 76 1 1 3 0.06 286 5.72 79 1 1 2 0.04 288 5.76 80 1 1 1 0.02 289 5.78 81 1 1 1 0.02 290 5.80 82 1 1 2 0.04 292 5.84 84 1 1 2 0.04 294 5.88 86 1 1 1 0.02 295 5.90 88 1 1 1 0.02 296 5.92 93 0 1 1 0.02 297 5.94 96 0 1 1 0.02 298 5.96 98 0 1 1 0.02 299 5.98 101 0 1 3 0.06 302 6.04 102 0 1 2 0.04 304 6.08 104 0 1 2 0.04 306 6.12 105 0 1 1 0.02 307 6.14 107 0 1 1 0.02 308 6.16 108 0 1 1 0.02 309 6.18 109 0 1 1 0.02 310 6.20 113 0 1 1 0.02 311 6.22 114 0 1 1 0.02 312 6.24 117 0 1 1 0.02 313 6.26 118 0 1 2 0.04 315 6.30 119 0 1 2 0.04 317 6.34 120 0 1 1 0.02 318 6.36 123 0 1 3 0.06 321 6.42 124 0 1 1 0.02 322 6.44 125 0 1 1 0.02 323 6.46 127 0 1 1 0.02 324 6.48 128 0 1 3 0.06 327 6.54 133 0 1 1 0.02 328 6.56 134 0 1 2 0.04 330 6.60 136 0 1 1 0.02 331 6.62 138 0 1 2 0.04 333 6.66 Research-Oriented Questions Using Simulated MB Health Data 17 Question 5 - Check new variables 13:24 Thursday, August 19, 1999 The FREQ Procedure Cumulative Cumulative DEATHSEP death90 deathall Frequency Percent Frequency Percent ------------------------------------------------------------------------------------ 139 0 1 1 0.02 334 6.68 142 0 1 1 0.02 335 6.70 144 0 1 1 0.02 336 6.72 146 0 1 1 0.02 337 6.74 147 0 1 2 0.04 339 6.78 148 0 1 1 0.02 340 6.80 155 0 1 1 0.02 341 6.82 156 0 1 2 0.04 343 6.86 157 0 1 1 0.02 344 6.88 160 0 1 1 0.02 345 6.90 163 0 1 3 0.06 348 6.96 166 0 1 3 0.06 351 7.02 168 0 1 1 0.02 352 7.04 170 0 1 2 0.04 354 7.08 171 0 1 1 0.02 355 7.10 175 0 1 1 0.02 356 7.12 178 0 1 1 0.02 357 7.14 180 0 1 1 0.02 358 7.16 184 0 1 1 0.02 359 7.18 185 0 1 1 0.02 360 7.20 187 0 1 2 0.04 362 7.24 188 0 1 1 0.02 363 7.26 189 0 1 1 0.02 364 7.28 191 0 1 1 0.02 365 7.30 193 0 1 3 0.06 368 7.36 197 0 1 2 0.04 370 7.40 199 0 1 1 0.02 371 7.42 201 0 1 1 0.02 372 7.44 207 0 1 1 0.02 373 7.46 209 0 1 1 0.02 374 7.48 210 0 1 2 0.04 376 7.52 214 0 1 3 0.06 379 7.58 218 0 1 2 0.04 381 7.62 223 0 1 1 0.02 382 7.64 225 0 1 1 0.02 383 7.66 228 0 1 1 0.02 384 7.68 229 0 1 1 0.02 385 7.70 232 0 1 1 0.02 386 7.72 238 0 1 1 0.02 387 7.74 241 0 1 1 0.02 388 7.76 243 0 1 1 0.02 389 7.78 244 0 1 1 0.02 390 7.80 247 0 1 1 0.02 391 7.82 250 0 1 1 0.02 392 7.84 253 0 1 1 0.02 393 7.86 254 0 1 2 0.04 395 7.90 Research-Oriented Questions Using Simulated MB Health Data 18 Question 5 - Check new variables 13:24 Thursday, August 19, 1999 The FREQ Procedure Cumulative Cumulative DEATHSEP death90 deathall Frequency Percent Frequency Percent ------------------------------------------------------------------------------------ 261 0 1 2 0.04 397 7.94 264 0 1 1 0.02 398 7.96 270 0 1 1 0.02 399 7.98 272 0 1 1 0.02 400 8.00 274 0 1 1 0.02 401 8.02 287 0 1 1 0.02 402 8.04 288 0 1 1 0.02 403 8.06 290 0 1 1 0.02 404 8.08 291 0 1 2 0.04 406 8.12 292 0 1 2 0.04 408 8.16 323 0 1 1 0.02 409 8.18 376 0 1 1 0.02 410 8.20 380 0 1 1 0.02 411 8.22 388 0 1 1 0.02 412 8.24 399 0 1 1 0.02 413 8.26 410 0 1 1 0.02 414 8.28 432 0 1 1 0.02 415 8.30 449 0 1 1 0.02 416 8.32 9999 0 0 4584 91.68 5000 100.00 Cumulative Cumulative deathall death90 Frequency Percent Frequency Percent ------------------------------------------------------------------------ 0 0 4584 91.68 4584 91.68 1 0 120 2.40 4704 94.08 1 1 296 5.92 5000 100.00 Research-Oriented Questions Using Simulated MB Health Data 19 Question 5: All deaths and 90-day mortality 13:24 Thursday, August 19, 1999 The FREQ Procedure Cumulative Cumulative deathall Frequency Percent Frequency Percent ------------------------------------------------------------- 0 4584 91.68 4584 91.68 1 416 8.32 5000 100.00 Cumulative Cumulative death90 Frequency Percent Frequency Percent ------------------------------------------------------------ 0 4704 94.08 4704 94.08 1 296 5.92 5000 100.00