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

st: converting a string variable that has leading and embedded blanks to a numeric variable.


From   Ali Murat <alimuratberker@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: converting a string variable that has leading and embedded blanks to a numeric variable.
Date   Tue, 8 Feb 2005 20:33:02 +0200

Hello all,

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.

Thank you all for your kind concern and help.

Best regards.

 

Ali M. Berker

*
*   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