[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

From |
Ali Murat <alimuratberker@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: RE: converting a string variable that has leading and embedded blanks to a numeric variable. |

Date |
Tue, 8 Feb 2005 21:07:30 +0200 |

My concern is that I need to transform the string hhid variable into the numeric one If I wantto use Stata commands such as sort, merge, collapse that all require a unique id variable for each observation- or group. 21blank 2 and blank212 are differen hhid numebers and belong to different households. When I use the following command destring newhhid, replace ignore(" ") hose two hhid numbers turned into the same numeric hhid variable hhid that makes impossible to differentiate between them. I hope now my question becomes clear. Thanks for your interest. Ali M. On Tue, 8 Feb 2005 18:38:04 -0000, Nick Cox <n.j.cox@durham.ac.uk> wrote: > Sorry, but what's the problem? > Stata did what you asked. If you > do in fact believe that the blanks > are somehow informative, your original > variable is the one to use. > > Nick > n.j.cox@durham.ac.uk > > Ali Murat > > > I am trying to convert a string household indentification variable > > ,that has leading and embedded blanks, to a numeric one. When I used > > the destring command, the new numeric household identification number > > has no longer unique values due to leading and embedded blanks in the > > orÄ±ginal string household identification variable. To be more > > precise, I would like to document what I have done so far: > > > > gen newhhid=hhid > > > > destring newhhid, replace ignore(" ") > > > > sort newid > > > > l hhid newhhid > > > > > > > > Obsnumber hhid newhhid > > > > 161. | 21 1 211 | > > > > 162. | 21 2 212 | > > > > 163. | 212 212 | > > > > 164. | 213 213 | > > > > 165. | 21 3 213 | > > > > |------------------------| > > > > 166. | 214 214 | > > > > 167. | 21 4 214 | > > > > > > > > Please note that the observation 162 and 163 have a distinct hhid; the > > fist has an embedded blankd, the second has a leading blank. However, > > after using the destring command, they have same hhid number. > > > > How can I fix this problem. > > * > * For searches and help try: > * http://www.stata.com/support/faqs/res/findit.html > * http://www.stata.com/support/statalist/faq > * http://www.ats.ucla.edu/stat/stata/ > * * For searches and help try: * http://www.stata.com/support/faqs/res/findit.html * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/

**References**:**st: RE: converting a string variable that has leading and embedded blanks to a numeric variable.***From:*"Nick Cox" <n.j.cox@durham.ac.uk>

- Prev by Date:
**st: Re: converting a string variable that has leading and embedded blanks to a numeric variable.** - Next by Date:
**st: Re: st. converting a string variable that has leading and embedded blanks to a numeric variable.** - Previous by thread:
**st: RE: converting a string variable that has leading and embedded blanks to a numeric variable.** - Next by thread:
**RE: st: RE: converting a string variable that has leading and embedded blanks to a numeric variable.** - Index(es):

© Copyright 1996–2016 StataCorp LP | Terms of use | Privacy | Contact us | What's new | Site index |