Statalist


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

RE: st: How to append two columns


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: How to append two columns
Date   Thu, 4 Sep 2008 13:46:44 +0100

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index