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/
