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

From |
"Marcela Perticara" <perticara@econ.tamu.edu> |

To |
<statalist@hsphsun2.harvard.edu> |

Subject |
st: Re: Formatting variables |

Date |
Thu, 13 Jun 2002 13:12:21 -0500 |

You can also use the substring function. qui gen str9 hhid=substr(snid,1,1)+"0"+substr(snid,2,7) Also keep in mind that you can check the length of the string in a previous command, and only execute this line for the observations or files where the string has eight digits instead of nine. ----- Original Message ----- From: "Siyam,AA (pgr)" <A.A.Siyam@lse.ac.uk> To: <statalist@hsphsun2.harvard.edu> Sent: Thursday, June 13, 2002 12:51 PM Subject: st: Formatting variables > Dear Stata-listers, > > I am sorry to bother you with, but I have checked the FAQ contents and have spent a few hours now trying to understand what STATA is doing with the following: > > basically I have an identification variable "snid" that should be made-up of 9 digits, arranged as follows > digit 1 = Oblast no. (1 to 8) > digits 2-3=rayon no. (01 to 09) > digits 4-5=population point (01 to 55) > digits 6-7=segment no. (01 to 18) > digits 8-9=household number (01 to 20) > > Instead for some of the files I have, "snid" coming out with 8 digits as a result of bad coding ( rayon number above should have been stored as 01 to 09 but instead was entered as 1 to 9). What I thought I could do was the following > > . destring id, gen(snid) float > . format snid %9.0f > . gen hhid=100000000 + (snid-10000000) > . format hhid %9.0f > . list snid hhid > snid hhid > 1. 11010101 101010104 > 2. 11010102 101010104 > 3. 11010103 101010104 > 4. 11010104 101010104 > ... > 24. 11010401 101010400 > 25. 11010402 101010400 > 26. 11010403 101010400 > 27. 11010404 101010400 > 28. 11010405 101010408 > 29. 11010406 101010408 > > I can see that "zero" has been added, I can't understand why is STATA changing the last two digits of the newly created variable "hhid" . > > Many thanks for your help in advance. > > Amani > * > * 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: Formatting variables***From:*"Siyam,AA (pgr)" <A.A.Siyam@lse.ac.uk>

- Prev by Date:
**st: More Tab and Matrix** - Next by Date:
**st: RE: Re: Formatting variables** - Previous by thread:
**Re: st: Formatting variables** - Next by thread:
**st: RE: Formatting variables** - Index(es):

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