Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

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>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: converting a string variable that has leading and embedded blanks to a numeric variable.
Date   Tue, 8 Feb 2005 18:38:04 -0000

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/



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