Statalist


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

RE: st: need help destringing a variable


From   "Frank de Libero" <fedmerchant@comcast.net>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: need help destringing a variable
Date   Fri, 14 Sep 2007 12:04:31 -0700

Using regex also works, and is more general:

gen numonly = regexs(1) if regexm(ns,"^([0-9]+)"

See -help regexm-

..Frank

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Svend Juul
Sent: Friday, September 14, 2007 11:36 AM
To: statalist@hsphsun2.harvard.edu
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:       sj@soci.au.dk 
_________________________________________________________ 

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



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