Weighting to Multiple Datasets

27 Aug

Say there are two datasets—one that carries attitudinal variables, and demographic variables (dataset 1), and another that carries just demographic variables (dataset 2). Also assume that Dataset 2 is the more accurate and larger dataset for demographics (e.g. CPS). Our goal is to weight a dataset (dataset 3) so that it is “closest” to the population at large on both socio-demographic characteristics and attitudinal variables. We can proceed in the following manner: weight Dataset 1 to Dataset 2, and then weight dataset 3 to dataset 1. This will mean multiplying the weights. One may also impute attitudes for the larger dataset (dataset 2), using a prediction model built using dataset 1, and then use the larger dataset to generalize to the population.