Hi
I am working with the World Bank's Enterprise Surveys, and want to append data from different countries. One of the variables I intend to keep is the region of the firm. But once I append the data for a one country to another, the codes for the using dataset automatically assume the labels of the first dataset.
for example, the region variable for Ghana is coded as follows:
1=Accra 2=Tema 3=North 4=Takoradi
and the region variable for Zambia is coded as follows:
1=Kitwe 2=Livingstone 3=Lusaka 4=Ndola
Once I append the Zambia dataset to the Ghana dataset, the region variable in the new dataset only contains regions in the
Ghana dataset, but this time with higher frequency for each region due to the addition of observations from the Zambia dataset.
Related Posts with Appending survey data
Extracting just the month as a new variable from a complete date Hi, I have a variable that shows me the date of funding in the format, "day, dd/month/year, time"…
tempname frames questionCan someone explain why posting to a temporary frame doesn't work in the code below whereas posting …
r(459);unconditional standard errors derived assuming full estimation sample; indepvars dropped observations from the estimation sampleHi, I am estimating (using Stata 15) an eprobit model with an endogenous treatment, for which I had…
merging panel datadear, I have 2 panel datasets which I want to merge. One dataset contains values from 2009 to 2015 …
Checking to see if one variable is bigger than the otherDear Stata Users, I have two variables (Goal & Pledged). As I am looking to see what is my idea…
Subscribe to:
Post Comments (Atom)
0 Response to Appending survey data
Post a Comment