Statalist


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

Re: st: Text to column in Stata


From   Kyle Hood <kyle.hood@yale.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Text to column in Stata
Date   Tue, 24 Mar 2009 14:35:07 -0700

I'm not precisely sure what you mean (is "A###" the value or the name of one of a bunch of variables?), but you could try

. help destring
(use option ignore("A") or ignore("B"))

Kyle

Tomas M wrote:
Hello all,

I have a string variable, say "A###" (i.e. A112, A222, A344, etc.).

How would I code in Stata to generate a new variable that includes only the "A"?

In summary, I have a variable, "A###", and I want to generate a new variable, "A".

Similarly, I have a variable, "B###", and I want to generate a new variable, "B".


Any ideas on how I can do this in Stata?

In Excel, I would just use text to columns, and break it down into two separate columns.  Anything like this in Stata?

Thank you!


_________________________________________________________________
Share photos with friends on Windows Live Messenger
http://go.microsoft.com/?linkid=9650734
*
*   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/


--
Kyle Hood
Department of Economics
Yale University
New Haven, CT
website: http://www.econ.yale.edu/~kkh25/

*
*   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   |   What's new   |   Site index