Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

RE: st: How to append two columns


From   John Ataguba <johnataguba@yahoo.co.uk>
To   statalist@hsphsun2.harvard.edu
Subject   RE: st: How to append two columns
Date   Thu, 4 Sep 2008 13:14:54 +0000 (GMT)

Thanks Nick.  The -egen newvar=concat(varlist) is more generic for me and will do. This is because you can combine it with destring if it was initially numeric.

Thanks for this.  

Regards

John


--- On Thu, 4/9/08, Nick Cox <n.j.cox@durham.ac.uk> wrote:

> From: Nick Cox <n.j.cox@durham.ac.uk>
> Subject: RE: st: How to append two columns
> To: statalist@hsphsun2.harvard.edu
> Date: Thursday, 4 September, 2008, 3:46 PM
> But there is a command to do it. This crossed with my post
> pointing that out. It is -egen, concat()-. Or alternatively
> this is possible with basic functions: 
> 
> gen var12 = real(string(var1) + string(var2)) 
> 
> or 
> 
> gen var12 = string(var1) + string(var2) 
> 
> or 
> 
> gen var12 = real(var1 + var2) 
> 
> or 
> 
> gen var12 = var1 + var2 
> 
> depending on what you have and what you want. (Your
> question did not specify whether you had numeric or string
> variables.) 
> 
> Nick 
> n.j.cox@durham.ac.uk 
> 
> John Ataguba
> 
> Thanks Johannes and Ashim.  The suggestions were great.  I
> thought there could be a command to just do this without
> going through manipulations.
> 
> Johannes Geyer
> 
> > You could generate strings from your numeric
> variables,
> > add them together and convert the string back to
> numeric:
> > 
> > *******************
> > clear
> > set obs 10
> > gen x = _n * 1000
> > gen y = _n
> > 
> > tostring x, generate(a)
> > tostring y, generate(b)
> > gen z = a + b
> > destring z, replace
> > 
> > ******************************
> > 
> 
> Ashim 
>  
> > > A crude way would be to multiply the 1st column
> by 10
> > and add the 2nd
> > > column to it ?
> 
> John Ataguba
> 
> > > > I am trying to append two colums in stata
> and I
> > was wondering if 
> > > this is possible.  Basically I have data in the
> > following way
> > > >
> > > > UQNo           PersonNo
> > > > 100012          1
> > > > 100012          2
> > > > 100012          3
> > > > 100024          1
> > > > 100024          2
> > > > 100019          1
> > > > 100019          2
> > > > 100019          3
> > > > 100055          1
> > > > 100075          1
> > > > 100075          2
> > > >
> > > > And I want to generate a new variable that
> will
> > look like
> > > >
> > > > UQNoP
> > > > 1000121
> > > > 1000122
> > > > 1000123
> > > > 1000241
> > > > 1000242
> > > > 1000191
> > > > 1000192
> > > > 1000193
> > > > 1000551
> > > > 1000751
> > > > 1000752
> 
> *
> *   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