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
[email protected] | p: (202) 238-3576
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Tomas M
Sent: Tuesday, March 24, 2009 5:34 PM
To: [email protected]
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: [email protected]
> To: [email protected]
> 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/
