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
Confidence interval for crude rateI would like to calculate the 95% confidence interval for the crude rate. How I could do it in STATA…
Test statistics and p-values different in SEM linear regression vs. OLSGreetings, I'm running Stata 15.1 on a Mac OS. I'm currently working with aggregate time series dat…
Correct date variableHi all, I hope someone can help here. I want to correct the first two digits of the year from a dat…
Multiple bars in a single chartHi all, I have very basic question that I cannot find an answer to. I have tried all sorts of option…
Creating observation pairs in Stata - balanced sample, no replacementHello, I am trying to create a balanced sample of paired observations in Stata based on a treated a…
Subscribe to:
Post Comments (Atom)
0 Response to Match value labels from two different datasets
Post a Comment