Statalist


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

RE: st: Text to column in Stata


From   Howard Lempel <HLempel@brookings.edu>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   RE: st: Text to column in Stata
Date   Tue, 24 Mar 2009 17:39:32 -0400

Hi there,

I think Martin has already given you what you want.  In addition, -help string_functions- will give you a whole bunch of commands for this sort of task.

Hope this helps.
Howie

Howie Lempel
Research Assistant
The Brookings Institution | Economic Studies
 
1775 Massachusetts Ave NW | Washington DC 20036
hlempel@brookings.edu | p: (202) 238-3576
 
-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Tomas M
Sent: Tuesday, March 24, 2009 5:34 PM
To: statalist@hsphsun2.harvard.edu
Subject: RE: st: Text to column in Stata

As a follow up,

I know of a command in Stata that only takes the year of a date,

e.g. generate newvar = year(date of birth), which will generate a new variable containing only the year of birth.

Something similar to this would be great!



----------------------------------------
> From: anon556656@live.ca
> To: statalist@hsphsun2.harvard.edu
> Subject: st: Text to column in Stata
> Date: Tue, 24 Mar 2009 14:29:23 -0700
>
> 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/

_________________________________________________________________
Experience all of the new features, and Reconnect with your life.
http://go.microsoft.com/?linkid=9650730
*
*   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/

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