Skip to main content

Table 4 Missingness and summary statistics for risk factor records

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

Smoking status

No. patients missing smoking record, n (%)

4716 (20.1)

5413 (21.7)

Unique values, n

4

4

3 most frequent values in all records, n (%)

“Unknown”: 17,942 (33.8)

“Never”: 16,760 (31.6)

“Current”: 11,799 (22.2)

“Never”: 20,018 (38.6)

“Unknown”: 18,812 (36.3)

“Current”: 7658 (14.8)

Mean number of smoking records per patient, n (SD)

2.8 (4.2)

2.7 (3.6)

Median number of smoking records per patient, n (IQR)

1.0 (2.0)

1.0 (2.0)

Smoking start date

No. records missing start date, n (%)

52,999 (99.9)

51,780 (99.9)

Smoking end date occurs before start date, n (%)

0 (0)

0 (0)

Alcohol use status

No. patients missing alcohol record, n (%)

12,372 (52.7)

15,034 (60.4)

Unique values, n

5

7

3 most frequent values in all records, n (%)

‘Current’: 7228 (93.6)

‘Past’: 479 (6.2)

‘Unknown’: 11 (0.1)

‘Current’: 6068 (94.8)

‘Past’: 220 (3.4)

‘Unknown’: 108 (1.7)

Mean number of alcohol records per patient, n (SD)

2.0 (2.2)

2.2 (2.6)

Median number of alcohol records per patient, n

1.0 (1.0)

1.0 (1.0)

Alcohol use start date

No. records missing start date, n (%)

21,939 (100)

22,127 (100)

Alcohol use end date occurs before start date, n (%)

0 (0)

0 (0)