Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


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

st: RE: assigning same number to slightly different string var.


From   Nick Cox <n.j.cox@durham.ac.uk>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   st: RE: assigning same number to slightly different string var.
Date   Tue, 1 Nov 2011 11:02:22 +0000

You want a new  variable, which could be constructed like this 

gen newvar = . 
replace newvar = 1 if strpos(myvar, "500") 
replace newvar = 2 if strpos(myvar, "Dax") 
... 

-if strpos(,)- is equivalent to -if strpos(,) > 0-. 

tab myvar if missing(newvar) 

will tell you what you missed. 

You will also want to define value labels and assign them. 

Nick 
n.j.cox@durham.ac.uk 

Philip Hantschk

i have a set of data containing names of indices, like S&P 500, Dax 30 etc. I want to assign numbers to the indices, so that S&P 500=1, Dax 30=2 etc. The problem is, that the in the observations, S&P 500 has different ways of writing, e.g. Standard and Poor's 500, S&P 500, S&P 500 Index, etc. 

My question is, is there a way to assign numbers automatically, like tell Stata to give every observation that contains "500" the "1".


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


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