Using regex also works, and is more general:
gen numonly = regexs(1) if regexm(ns,"^([0-9]+)"
See -help regexm-
..Frank
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Svend Juul
Sent: Friday, September 14, 2007 11:36 AM
To: [email protected]
Subject: Re: st: need help destringing a variable
James wrote:
I just want to convert all the strings in one variable
into integers. e.g., the variable is grade_school
(current grade in school) and the variable column has
"2nd" "5th" etc., and I want to make it "2", "5" by
issuing just one command.
---------------------------------------------------------
-destring- with the -ignore()- option does it. Try this:
clear
input str4 ns
1st
2nd
3rd
4th
5th
10th
end
destring ns , generate(n) ignore("s, t, n, d, r, h")
Hope this helps
Svend
________________________________________________________
Svend Juul
Institut for Folkesundhed, Afdeling for Epidemiologi
(Institute of Public Health, Department of Epidemiology)
Vennelyst Boulevard 6
DK-8000 Aarhus C, Denmark
Phone, work: +45 8942 6090
Phone, home: +45 8693 7796
Fax: +45 8613 1580
E-mail: [email protected]
_________________________________________________________
*
* 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/