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

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/

**Follow-Ups**:**RE: st: How to append two columns***From:*"Nick Cox" <n.j.cox@durham.ac.uk>

**References**:**RE: st: How to append two columns***From:*"Nick Cox" <n.j.cox@durham.ac.uk>

- Prev by Date:
**st: RE: Re: table with zero rows** - Next by Date:
**Re: st: RE: Re: table with zero rows** - Previous by thread:
**RE: st: How to append two columns** - Next by thread:
**RE: st: How to append two columns** - Index(es):

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