[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
"Nick Cox" <n.j.cox@durham.ac.uk> |

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

Subject |
st: RE: Problems adding large numbers |

Date |
Wed, 28 Oct 2009 12:50:28 -0000 |

As Martin Weiss has implied, this is a precision problem. It is aired monthly (if not weekly) on this list. You could tackle it by specifying storage type as in Martin's code. Alternatively, hold the identifiers as strings. You can combine by concatenation. -egen, concat()- will do that for you and handle any conversion issues. That practice is entirely consistent with identifiers having numeric characters as content, later extraction of substrings, etc. Nick n.j.cox@durham.ac.uk Shruti Kapoor i have a huge individual level dataset. I am trying to generate a new variable x which is the sum of my household id(HHID) and person number in each household (PERNUM) for some condition if it is true. The problem i am facing is that at very large values of HHID lets say 16817000, if the PERNUM is 4 and 5 if should generate variable x = 16817004 and 16817005. What stata is doing is rounding off the numbers so that i am getting the same values for both PERNUM 4 and 5. This is a problem because it is no longer creating a unique value of X which i need. I string to convert the two variables into string and then creating x = HHID + PERNUM, but now i am getting answers like 1.68e10+05. How can i resolve this issue such that it creates a unique value for each individual in the household and x stays numeric? * * 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/

**Follow-Ups**:**st: AW: RE: Problems adding large numbers***From:*"Martin Weiss" <martin.weiss1@gmx.de>

**References**:**st: Problems adding large numbers***From:*Shruti Kapoor <kapoor@oxy.edu>

- Prev by Date:
**Re: st: probability question** - Next by Date:
**st: RE: probability question** - Previous by thread:
**st: AW: AW: Problems adding large numbers** - Next by thread:
**st: AW: RE: Problems adding large numbers** - Index(es):

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