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/
