Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: st: Basic Numeric to String Recoding
From
Nick Cox <[email protected]>
To
"'[email protected]'" <[email protected]>
Subject
RE: st: Basic Numeric to String Recoding
Date
Mon, 6 Sep 2010 22:52:38 +0100
Good point! Just having my little bit of fun....
Nick
[email protected]
Eric Booth
I used that order because that's how -encode- encodes "state2" when using "census.dta"; however, if you sort on "state2" before encoding, you will get proper alphabetic order (and you'll need to change the -label define- statement in my code accordingly).
Nick Cox
Eric's spirit is exactly right, but those over 40 were taught the alphabet....
"Alabama" comes before "Alaska", modulo Sarah Palin. "Arizona" also comes before "Arkansas".
Eric Booth
Something like this:
****************!
**set up**
sysuse census, clear
keep state2 pop
encode state2 , g(state3)
lab li
**********
lab def fullstates 1 "Alaska" 2 "Alabama" 3 "Arkansas" ///
4 "Arizona" 5 "California" 6 "Colorado", modify
**and so on...
lab val state3 fullstates
lab li
li state3 state2 //<-- make sure these line up
****************!
~ Eric
__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
[email protected]
Office: +979.845.6754
On Sep 6, 2010, at 4:17 PM, Benhoen2 wrote:
> I am a new user - please forgive me.
>
> I have a list of numeric IDs for states (stateid) with abbreviated labels
> attached (stname). I would like to create a new string variable made us of
> the unabbreviated state names but based on the stateid variable.
>
> I have tried the following:
> 1) recode stateid (1="Alabama"), (2="Arkansas"), ..., generate(statename)
> 2) recode stateid (1="Alabama"), (2="Arkansas"), ..., strgen(statename)
> 3) generate state="Alabama" if stateid=1
>
> among other nonsensical permutations. Is there any way to do this using
> recode, or something analogous?
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/