Table 2. Completeness of each variable in the national high-cost drugs dataset.
| Variable
Name |
Records for FY 2018/19 | Records for FY 2019/20 | ||||||
|---|---|---|---|---|---|---|---|---|
| Total
records |
%
missing |
%
Numeric (and not missing) |
Number
of unique values |
Total
Records |
%
missing |
%
Numeric (and not missing) |
Number
of unique values |
|
| PersonAge | 2,799,394 | 1.8% | 100.0% | 114 | 3,984,198 | 2.9% | 100.0% | 125 |
| PersonGender | 2,799,394 | 0.0% | 100.0% | 3 | 3,984,198 | 0.0% | 100.0% | 4 |
| Activity
Treatment FunctionCode |
2,799,394 | 9.2% | 100.0% | 144 | 3,984,198 | 6.0% | 100.0% | 143 |
| Therapeutic
IndicationCode |
2,799,394 | 49.6% | 12.6% | 7,230 | 3,984,198 | 68.3% | 36.0% | 5,130 |
| HighCostTariff
Excluded DrugCode |
2,799,394 | 29.0% | 78.9% | 12,687 | 3,984,198 | 43.5% | 87.9% | 11,722 |
| DrugName | 2,799,394 | 1.0% | 0.0% | 20,698 | 3,984,198 | 1.4% | 0.1% | 19,609 |
| RouteOf
Administration |
2,799,394 | 7.3% | 2.3% | 1,213 | 3,984,198 | 41.8% | 69.9% | 625 |
| DrugStrength | 2,799,394 | 24.1% | 11.8% | 22,887 | 3,984,198 | 31.4% | 13.1% | 9,091 |
| DrugVolume | 2,799,394 | 42.2% | 30.3% | 12,168 | 3,984,198 | 60.8% | 22.7% | 7,472 |
| DrugPackSize | 2,799,394 | 21.8% | 35.6% | 7,952 | 3,984,198 | 24.7% | 48.2% | 7,156 |
| DrugQuanitity
OrWeight Proportion |
2,799,394 | 6.8% | 65.5% | 10,349 | 3,984,198 | 7,4% | 65.5% | 13,871 |
| UnitOf
Measurement |
2,799,394 | 100.0% 1 | 23.4% | 57 | 3,984,198 | 77.7% | 84.5% | 853 |
| Dispensing Route | 2,799,394 | 12.4% | 97.7% | 235 | 3,984,198 | 24.6% | 99.1% | 36 |
| HomeDelivery
Charge |
2,799,394 | 1.8% | 100.0% | 6,190 | 3,984,198 | 3.8% | 100.0% | 11,639 |
| TotalCost | 2,799,394 | 0.2% | 100.0% | 160,060 | 3,984,198 | 0.0% | 100.0% | 169,294 |
| Derived
SNOMED |
2,799,394 | 92.3% | 100.0% | 205 | 3,984,198 | 91.7% | 100.0% | 218 |
| DerivedVTM | 2,799,394 | 30.6% | 100.0% | 684 | 3,984,198 | 36.5% | 100.0% | 737 |
| DerivedVTM
Name |
2,799,394 | 30.6% | 0.0% | 682 | 3,984,198 | 36.5% | 0.0% | 736 |
1 Rounded to nearest decimal point - there are 657 non-missing records in total out of 2,799,394