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

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/

**Follow-Ups**:**RE: st: How to append two columns***From:*John Ataguba <johnataguba@yahoo.co.uk>

**References**:**Re: st: How to append two columns***From:*Johannes Geyer <JGeyer@diw.de>

**Re: st: How to append two columns***From:*John Ataguba <johnataguba@yahoo.co.uk>

- Prev by Date:
**Re: st: RE: Changing property of a variable into number** - Next by Date:
**Re: st: Treating multiple-variables as one** - Previous by thread:
**Re: st: How to append two columns** - Next by thread:
**RE: st: How to append two columns** - Index(es):

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