From | Gary Longton <[email protected]> |
To | [email protected] |
Subject | Re: st: Converting strings to Numerics |
Date | Tue, 23 Dec 2003 11:00:47 -0800 |
Fultz, Shawn wrote:
I am trying to convert a series of string variables to numeric variables. Because some of the numbers contain commas, the real() function does not work, instead returning a missing value. What I get String Number 5.3 5.3 hello .2 .2,500,000 . What I want to get String Number 5.3 5.3 hello .2 22,500,000 2500000 Is there any way to extract a numeric value from the string variable?
see help for -destring- you'll want to use the -,ignore()- option. i.e. destring <stringvar>, gen(new_numeric_var) ignore(,) - Gary * * 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–2024 StataCorp LLC | Terms of use | Privacy | Contact us | What's new | Site index |