Hello all,
I am seeking help with the following. I have a dataset that is of population projections for each county in a state. There are 58 observations for the "county" variable, currently coded according to their FIPs (Federal Information Processing Standards) county code. For example, the value 6001 corresponds to Alameda county. The actual county names are only in the data dictionary. The dataset itself only has the FIPS codes.
What I am trying to do is use the command "label define" to define a label named County so that instead of reading the value "6001" when I browse my data, I can read "Alameda." I have used "label define" before but only very simply (for example, label define Sex 0 "Female" 1 "Male"). The code I have so far is what follows:
label define County 6001 "Alameda" 6003 "Alpine" 6005 "Amador" 6007 "Butte" 6009 "Calaveras" 6011 "Colusa" 6013 "Contra Costa"
Do I have to complete this process for every single one of the 58 observations? Is there a simpler way or do I need to just import the data with the county names replacing the FIPS codes before I even begin working with Stata?
Many thanks,
Esi
Related Posts with Using Label define for a variable with many observations
Comparing samplesDear Stata users, I will please like some explanation. I am working on the topic "the effect of chi…
project management in StataI'm looking for a good way to do proper project management in Stata. Some info: 1) I have lots of d…
non-convergent multiple group CFAs using gsemI am running a multiple group CFAs to test for measurement invariance across groups (sexes) on a sur…
Different outcome rhausman vs xtoveridHi everyone. I'm doing research on the effects of CEO personality on the debt ratio of Belgian list…
panel data: aggregate imputed variables to a new variable using miI am working with panel data for two waves at the moment. The dependent variable (outcome) is a bina…
Subscribe to:
Post Comments (Atom)
0 Response to Using Label define for a variable with many observations
Post a Comment