Abstract
Linkage of different data sources is an intermediate step in many statistical processes. When dealing with data resulting from a record linkage process, it should be considered that the linkage is affected by two types of errors: false links and missed matches. If the linkage errors are not properly taken into account, i.e. standard statistical procedures are applied to the linked data, biased estimates and mis-relationships between variables recorded in different sources may result. This paper provides a sensitivity analysis of the effect of linkage errors on the estimation of linear and logistic regressions. Different linkage scenarios are proposed, with various matching variables and accordingly different linkage error levels. The analysis confirms the importance of linkage errors and highlights the relevance of missed matches. The effectiveness of the proposed adjustment methods is demonstrated even when the conditions for their applicability are not fully satisfied, however a framework for taking into account the complexity of linkage procedures is needed.
Introduction
The considerable effort to link data coming from different sources is not the objective of the statistical process but only an intermediate step. When dealing with data resulting from a record linkage process, it should be considered that the linkage can be affected by two types of errors: false links and missed matches.
In fact, these errors may affect the standard statistical analyses and if they are not properly taken into account, i.e. the standard statistical procedures are applied to the linked data, biased estimates and mis-relationships between variables recorded on different sources may result.
In recent years, increasing attention has been paid to tailored estimation procedures to take into account linkage errors. This paper aims at answering the question about the conditions for the negligibility of linkage error effects on estimation. The effects of different error levels are analysed in a simulated setting that reproduces real linkage procedures. We propose a sensitivity analysis of the impact of linkage errors on linear and logistic regressions, we assume different linkage scenarios, with various matching variables characterised by different degrees of identifying power.
The paper is organized as follows: Section 2 reviews the effect of linkage errors on the total survey errors and briefly describes the probabilistic record linkage. Section 3 provides a brief account of the literature on statistical inference in the presence of linkage errors. In Section 4 the results of the sensitivity analysis are reported and discussed; finally, in Section 5, the outstanding issues are left open for future research.
Linkage errors and total survey errors
In a context where the integration of sources has acquired a preeminent role, the relevance of considering linkage errors in the total survey error representation has been acknowledged. See, for example, the extensions of the life cycle model of a statistical survey in Groves et al. [1] proposed by Bakker [2] and Zhang [3] for the integration of administrative data. Zhang [3] illustrates a representation where the linkage process is recognised as a possible cause of identification errors.
The total survey error in Biemer [4] classifies the various causes of errors. In his schema, the linkage procedures, as a step in data processing (see GSBPM v. 5), affect both measurement and frame errors.
In this paper, the attention is focused on the effect of linkage errors on relationships between variables, recorded in different sources. The probabilistic linkage process that generates linkage errors is briefly outlined in the next subsection.
The probabilistic record linkage
The fundamental theory of probabilistic record linkage is given by Fellegi and Sunter [5]. Given two lists, say L1 and L2, of size
In order to assign pairs to the sets
is used for classifying the pairs. The two probabilities
The thresholds
The described linkage model also allows for the evaluation of the probability that a link is correct given that the link is assigned, the so-called true match rate:
The parameter
The effect of linkage errors on the linear regression model estimation was firstly illustrated by Neter et al. [7]. They show that even small linkage errors may produce a large bias in estimation procedures that do not tackle them. The original proposal for dealing with linkage errors [7] is subject to some restrictive assumptions: the two files have the same size and each record from one file is linked to a record in the second file with a constant probability
Following their seminal paper, in recent years, many proposals have been suggested to provide sound inference in the presence of linkage errors. Scheuren and Winkler [8, 9] and Lahiri and Larsen [10] extend the original work of Neter et al. [7] and propose methods for the unbiased estimation of linear regression coefficients under probabilistic record linkage, applying a bias correction to the Ordinary Least Squares (OLS) estimates.
In particular, Scheuren and Winkler [8, 9] propose a ratio-type correction of the bias of the standard estimator on the basis of two critical assumptions: the probability of being a true match is known for each pair; the true match is the pair with the highest matching weight (probability).
Lahiri and Larsen [10] estimate the regression model between the linked values and the auxiliary variables. Their estimator still depends on the assumption of homoscedasticity. However, this condition generally is not satisfied, therefore, to relax this assumption, Chambers [11] suggests a Best Unbiased Estimator (BLUE) or its empirical (EBLUE) version.
Extensions to generalized linear models by means of generalised estimating equations (GEE) are proposed in Chambers [11] and Chambers et al. [12]. The GEE method [11] is subject to the same strong conditions as in the linear case: both registers have to be complete and no duplicates occur. An exchangeable linkage errors model is assumed, at least into groups of records.
Besides the EBLUE, Chambers [11] proposes a maximum likelihood (ML) estimator with application to the linear and logistic regression.
Finally, Chambers [11] considers the cases where the linkage is incomplete, i.e. one of the registers is a subset of the other register, as it is common in real data applications. The previous estimators can be extended to these cases under the assumption of no interaction between the sample selection process and the linkage error one, via weighted estimating functions. Kim and Chambers [13] apply the estimating equations as in Chambers [11] to deal with unlinked data and non-ignorable linkage models. Further analyses are needed in this context due to the strong assumptions and the limitation to the linear regression.
In the same setting of Chambers [11], Samart [14] extends the method to the class of linear mixed models. These models are very useful in the context of dependent observations, to take into account of intra-correlation of clustered units, e.g. students in a school, patients in a hospital, and they are largely exploited in Official Statistics for small area estimation. Proposals for small area estimation with linked data are in [15, 16].
Finally, Chipperfield et al. [17] develop a ML approach for the analysis of probabilistically-linked records. The estimation technique is simple and it is implemented using the well-known EM algorithm. This method removes the limitation that all records have to be linked. This is a very important extension for dealing with administrative data when the different sources do not contain the same units or a file is not a subset of the other, as assumed in [11]. Moreover, their method explicitly considers both unlinked data and missed links. Furthermore, unlike in [7, 11] and the extensions discussed above, the method does not require exchangeability of linkage errors, even in groups of records. Therefore, it can also be applied when the linkage runs in several steps, as it is very frequent in real applications. They illustrate the method both for the analysis of contingency table and the logistic regression.
In the Bayesian approach, Fortini et al. [18] propose a different perspective to probabilistic record linkage. The objective of the inference is a linkage matrix C of size
In the Bayesian approach, the inference can be carried out at the same time of the record linkage procedure, i.e. the relationships between variables are estimated via the MCMC process simultaneously with the linkage model.
This means that at each iteration
The process causes a feed-back propagation of the information between the record linkage parameters and the more specific target quantities; i.e. the regression model depends on the selected matches, but even the selection of potential links depends on the information carried by the regression model. Tancredi and Liseo [19] illustrate the idea of feed-back propagation only for multiple linear regression, however no limitation prevents the application of the method to more general models. Nevertheless, as far as our knowledge, this method is computationally very costly and it is hardly practical for high-dimensional problems.
More recently, Steorts et al. [20] propose an alternative Bayesian approach that allows linking records from multiple lists simultaneously and at the same time de-duplicating the lists. The linkage is formulated as the process of recognising latent “entities” with a graphical representation, i.e. each record in the lists can be linked to a latent unit from 1 to
A sensitivity analysis
The previous section summaries the increasing attention to linkage errors in statistical analyses on probabilistically linked data. However, the analyst may wonder whether to adopt sophisticated estimation procedures to adjust for linkage errors, or whether there are levels of linkage errors that can be ignored in subsequent analyses. Winkler [21] notes “Scheuren and Winkler [9] observed that, if linkage error is below 1%, then can perform statistical analysis without adjustment. Most ‘good’ matching situations have overall linkage error above 10%. Even ‘high match scores’ sets of pairs may have linkage error in range 1–5%. The current models may adjust the ‘observed’ matched pairs to having linkage error down from 10% to 7.5%. Bringing in sophisticated models that include edit/imputation may lower observed error to 5%. Further improved models may drop observed linkage error to 2.5%.”
This paper aims at investigating whether linkage error adjustment is necessary, showing the effects of different error levels produced by real linkage procedures. To this purpose, we conduct a sensitivity study to analyze the impact of linkage errors in different scenarios in terms of match rates and linkage errors. We analyse the effectiveness of the most common adjustment methods for linear and logistic regressions, referred to in Section 3, with the aim of highlighting the gain in accuracy due to the adjustment of linkage errors. The applied estimators are described in Subsection 4.1. The fictitious population used for the sensitivity analysis is introduced in Section 4.2.
Adjusted estimators for linkage errors in regression models
Let
Due to linkage, the observed target variable is
Chambers [11] defines an exchangeable linkage errors model by assuming that the probability of correct linkage is the same for all records, or at least the probability is the same in groups partitioning the whole observations.
Chambers [11] models the relationship between the probabilistically linked data and the true data:
The exchangeability of linkage errors; The linkage is complete, i.e. the The linkage is one-to-one between the two lists.
As mentioned in Section 3.1, Scheuren and Winkler [8] propose a biased corrected OLS estimator of
where the matrix
Alternatively, modeling the relationship between the linked data and the covariates, under the assumption of homoscedasticity, Lahiri and Larsen [10] propose the following estimator:
To take also into account the heterogeneity, Chambers [11] proposes a Best Linear Unbiased Estimator (BLUE) of
where
For the linear logistic model,
where
Under perfect linkage, the logistic model is fitted via ML with
Alternatively, the function
and
In the following, we denote the estimators from Eqs (9)–(11) as
For the sensitivity analysis, the fictitious population generated by the data from the ESSnet DI [22] is used; the ESSnet DI was a European project on data integration (Record Linkage, Statistical Matching, Micro integration Processing) run from 2009 to 2011. The data are freely available online at
The ESSnet DI datasets are augmented with an explanatory and dependent variables. For the linear regression model, the variables are generated according to the following model as in Chambers [11]:
For the logistic model, the variable
For this analysis, 100 samples of size 1000 are generated, sampling the data independently and randomly without replacement. Then from each sample, two different lists are generated mimicking the undercoverage of register data and the presence of errors in identifiers. The coverage rates of the two lists, say L1 and L2, are 0.93 and 0.92 respectively. The auxiliary variable and the target variable are separately assigned in list L1 and L2 respectively.
Results of linkage procedures in the three scenarios
Results of linkage procedures in the three scenarios
Linear model – naive and adjusted estimators
Average values on 100 replicates.
Three different linkage scenarios are proposed. In the first scenario, the Gold scenario, the variables with the highest identifying power are used as linking variables (Name, Surname, Complete date of birth). A second scenario, the Silver scenario, is considered applying the linkage with less variables (Complete date of birth, i.e., Day, Month and Year of Birth). Finally, the third scenario, the Bronze scenario, uses variables with the least identifying power, being more affected by errors than the others are (Surname, Day and Month of Birth).
The probabilistic record linkage is performed, according to the Fellegi and Sunter theory [5] as implemented in the RELAIS software [22].
Table 1 summaries the results of the linkage procedures, averaging on the 100 replicas, the table reports the number of the true matches, the number of declared links by the procedure, the percentage of false match rate (
The Gold scenario gives almost no false matches but only missing matches. On the other hand, the Silver and Bronze scenarios result in both false matches and missing matches, with different error rates.
As the true matching status is known, the true error rates (
The quantity (
Linkage errors in the three Scenarios.
The error (
Percentage of relative errors for true values, standard estimators and adjusted estimators in linear regression model.
The three scenarios produce increasing values of false and missing match rates. Primarily, the false match rate is under control, as in real practical applications where a conservative linkage strategy is often preferred; indeed, in our worst scenario the values of the false match rate are less than 5%. On the other hand, the control of the false match rate results in an increase of the missing match rate, which takes up to 20% in the Bronze Scenario.
However, under the standard assumption of ignorability of the missing linkage mechanism, one expects that the presence of missing matches does not introduce bias in the estimates even if it has an impact on their variability.
Logistic model – naive and adjusted estimators
Average values on 100 replicates.
The following tables show the results of the previous estimators Eqs (4)–(7) for the linear model as well as of the standard estimator and the derived estimators from Eqs (9)–(11) for the logistic model.
As already mentioned in Section 3, the assumptions of the methods proposed in Chambers [11] are far to be met in practical situations. In our simulation, although different real contexts are reproduced, the exchangeability is assumed for the application of the adjusted estimators. Even if the assumption of exchangeability of linkage errors is not met even in sub-groups, only one block is considered and an overall value of the probability of correct match
Table 2 reports the values of the linear regression model parameters and their relative standard errors for the naïve (4) and the adjusted estimators, SW (5), LL (6) and C (7), as well as the true values calculated on the whole population of 26450 records and the estimates obtained with the sample under perfect linkage.
Percentage of relative errors for true values, standard estimators and adjusted estimators in logistic regression model.
In Fig. 2, the percentage relative errors of the estimates under perfect linkage (TR), the naïve estimates in case of linkage errors (N) and the adjusted estimates in linear regression model are plotted.
As expected, the presence of false matches weakens the correlation between
The results of the logistic regression model are summarised in Table 3, where the parameter estimates and their relative standard errors are reported, averaging on 100 replicas. The table also shows the number of time the confidence intervals of the obtained estimates contains the true parameter value, i.e. the coverage of the nominal 95% CIs.
In Fig. 3 the distributions of relative errors of parameter estimates are plotted.
For categorical data, the false match error has less impact because of the nature of the response variable: the values of
The results of the coverage evaluation show that the standard error evaluation might be severely affected by underestimation.
These results suggest that the missing matches should also be taken into account to completely remove the bias. Indeed, in the Gold scenario, where the false matches are close to zero, the naïve and the adjusted estimators are still biased due to a not-ignorable missing mechanism. The bias effect of the missing matches is also shown in the other scenarios, where the adjustments for false matches reduce the bias but do not eliminate it. In any case, the correction for the bias is more effective in the linear than in the logistic model: in linear regression, we achieve a bias reduction of about 10% for the Bronze scenario and a little smaller in the Silver one. However, more work is needed for the estimation of the logistic regression, where the naïve estimator is slightly closer to the benchmark value than the adjusted ones, but about 15% of the replicas produces values out of the nominal 95% CI.
As expected, the comparison of the standard errors of the estimator under perfect linkage and the naïve estimator shows that the occurrence of missed matches also produces an increase in variance due to the reduction of the observed sample size, similarly to a missing value mechanism.
This work proposes a sensitivity analysis of the effect of linkage errors both on bias and variability of regression estimates, when linkage errors are assumed to be known. The need for the adjustment is evident even with small level of false matches. In our simulation, an average false match error of around 2% results in a percentage relative bias of the intercept and the slope of regression models respectively equal to 4.86% and
In the linear case, the adjustment is effective in reducing the bias without an appreciable increase in the standard errors of the estimates, when the linkage errors are known. However, further analysis should be conducted to assess the trade-off between the adjustment of the bias and the expected increase in variance when one needs to estimate the linkage errors, as it is usual in practice. Actually, the linkage errors evaluation is not a straightforward task, some proposals are in Belin and Rubin [24] and Tuoto [25].
As observed above, the bias associated to missed matches is also substantial, since in practice the ignorability assumption of the linkage mechanism may be unmet; hence the role of the missing matches should be further analysed.
As shown in this work, the model proposed in Chambers [11] enables the reduction of the bias but it does not consider all the complexities of a real linkage procedure (see Sections 3 and 4). Chipperfield et al. [17] propose a model which is subject to less stringent assumptions on linkage errors than the Chambers’s model. Their proposal does not require the exchangeability of linkage errors and considers explicitly the erroneous missed matches in the adjustment. It would be interesting to compare the two approaches in a simulation setting based on a real linkage procedure.
Footnotes
Acknowledgments
We wish to thank the Editor-in-Chief Kirsten West for encouraging us to improve an earlier version of the manuscript and Prof. Li-Chun Zhang for useful comments and discussion.
