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 <[email protected]> wrote:
> From: Nick Cox <[email protected]>
> Subject: RE: st: How to append two columns
> To: [email protected]
> 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
> [email protected]
>
> 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/
