Skip to main content

Table 2 Missingness and summary statistics for physical measurements and laboratory values

From: A data quality assessment to inform hypertension surveillance using primary care electronic medical record data from Alberta, Canada

Data element

Summary

Males

N = 23,486

Females

N = 24,889

Height (cm)

No. patients missing, n (%)

2391 (10.2)

2345 (9.4)

Patients with a measurement in previous year, n (%)

11,604 (49.4)

12,562 (50.5)

Range

41.9–229.6

37.2–229.0

Mean (SD)

174.6 (8.2)

160.8 (7.5)

Median (IQR)

175.0 (10.0)

161.0 (9.2)

Median number of total measurements per patient, n

4.0

5.0

Weight (kg)

No. patients missing, n (%)

1791 (7.6)

1714 (6.9)

Patients with a measurement in previous year, n (%)

12,165 (51.8)

13,241 (53.2)

Range

1.0–500.0

1.8–477.0

Mean (SD)

104.9 (41.5)

90.4 (39.0)

Median (IQR)

94.0 (30.3)

80.0 (33.0)

Median number of total measurements per patient, n

4.0

5.0

BMI (kg/m2)

No. patients missing, n (%)

2422 (10.3)

2316 (9.3)

Patients with a measurement in previous year, n (%)

11,979 (51.0)

13,062 (52.5)

Range

5.1–199.9

5.0–200.0

Mean (SD)

31.8 (9.5)

32.2 (11.1)

Median (IQR)

30.2 (7.4)

30.1 (10.1)

Median number of total measurements per patient, n

4.0

5.0

Systolic blood pressure (mmHg)

No. patients missing, n (%)

226 (1.0)

264 (1.1)

Patients with a measurement in previous year, n (%)

19,898 (84.7)

21,069 (84.6)

Range

52.0–266.0

54.0–290.0

Mean (SD)

134.4 (17.2)

134.6 (17.7)

Median (IQR)

133.0 (22.0)

133.0 (23.0)

Median number of total measurements per patient, n

16.0

18.0

Diastolic blood pressure (mmHg)

No. patients missing, n (%)

226 (1.0)

264 (1.1)

Patients with a measurement in previous year, n (%)

19,898 (84.7)

21,069 (84.6)

Range

30.0–188.0

30.0–200.0

Mean (SD)

80.4 (11.5)

78.8 (11.0)

Median (IQR)

80.0 (16.0)

80.0 (15.0)

Median number of total measurements per patient, n

16.0

18.0

Fasting glucose (mmol/L)

No. patients missing, n (%)

5005 (21.3)

5223 (21.0)

Patients with a measurement in previous year, n (%)

2969 (12.6)

2826 (11.4)

Range

1.6–42.9

1.5–35.0

Mean (SD)

6.4 (2.0)

6.0 (1.8)

Median (IQR)

5.7 (1.5)

5.5 (1.2)

Median number of total measurements per patient, n

4.0

4.0

Hemoglobin A1C (%)

No. patients missing, n (%)

2905 (12.4)

3283 (13.2)

Patients with a measurement in previous year, n (%)

12,471 (53.1)

12,305 (49.4)

Range

3.1–18.6

1.0–18.2

Mean (SD)

6.7 (1.4)

6.6 (1.3)

Median (IQR)

6.3 (1.6)

6.2 (1.3)

Median number of total measurements per patient, n

4.0

3.0

Low-density lipoprotein (LDL) cholesterol (mmol/L)

No. patients missing, n (%)

1888 (8.0)

2343 (9.4)

Patients with a measurement in previous year, n (%)

9429 (40.1)

9249 (37.2)

Range

0.0–9.8

0.0–9.5

Mean (SD)

2.5 (1.0)

2.8 (1.0)

Median (IQR)

2.4 (1.4)

2.7 (1.3)

Median number of total measurements per patient, n

5.5

4.0

High-density lipoprotein (HDL) cholesterol (mmol/L)

No. patients missing, n (%)

1725 (7.3)

2277 (9.1)

Patients with a measurement in previous year, n (%)

9616 (40.9)

9294 (37.3)

Range

0.0–6.5

0.2–7.0

Mean (SD)

1.2 (0.3)

1.5 (0.4)

Median (IQR)

1.1 (0.4)

1.4 (0.5)

Median number of total measurements per patient, n

4.0

4.0

Total cholesterol (mmol/L)

No. patients missing, n (%)

1714 (7.3)

2233 (9.0)

Patients with a measurement in previous year, n (%)

9659 (41.1)

9338 (37.5)

Range

0.7–23.3

0.6–21.5

Mean (SD)

4.5 (1.1)

5.0 (1.1)

Median (IQR)

4.4 (1.6)

4.9 (1.5)

Median number of total measurements per patient, n

5.0

5.0

Triglycerides (mmol/L)

No. patients missing, n (%)

1713 (7.3)

2261 (9.1)

Patients with a measurement in previous year, n (%)

9771 (41.6)

9414 (37.8)

Range

0.2–29.6

0.2–29.9

Mean (SD)

1.8 (1.3)

1.7 (1.0)

Median (IQR)

1.5 (1.1)

1.5 (1.0)

Median number of total measurements per patient, n

5.0

4.0

  1. BMI body mass index, cm centimetres, HDL high-density lipoprotein, IQR interquartile range, kg kilograms, LDL low-density lipoprotein, mmHg millimeter of mercury, mmol/L millimoles per litre, SD standard deviation