Re: st: Text to column in Stata

[Kyle Hood <kyle.hood@yale.edu>]

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/