Dear Statalisters
I have two different datasets with information on States and Districts. Since they're two different sources, the numeric values attached to the value labels are different. (the dist and stat are the numeric values attached to the State and District)
eg:
Data Set 1
State District dist stat
Haryana Ambala 1 4
Haryana Kaithal 2 4
Haryana Sonipat 3 4
Data Set 2
State District dist stat
Haryana sonipat 11 8
Haryana kaithal 15 8
Haryana ambala 7 8
What could I do to match/merge these two data sources on district? How could I change the numeric values of either one of them to match the other so that they could be merged?
Thank You for your help
Sayli
Related Posts with Match value labels from two different datasets
Using rdrobust with panel data, error 3301I am using a cleaned, balanced panel on retirement behaviour with Stata 16. One of the questions I'm…
Binary Endogenous variable in Negative binomial regressionHello everybody, In my research, the dependent variable (DV) is count data and endogenous variable …
Leave One Out Cross ValidationHello, I am trying to look for the best n given: set obs 200 gen x = runiform(0,5) gen U = rnorma…
Gravity estimation including fixed effectsHi everyone, I am estimating a gravity model of trade including exporter-time and importer-time fix…
Estimating bias in Endogenous Poisson modelsHi all, the title quite speaks for itself. I am trying to recover how the bias intervenes in the es…
Subscribe to:
Post Comments (Atom)
0 Response to Match value labels from two different datasets
Post a Comment