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

From |
John Ataguba <[email protected]> |

To |
[email protected] |

Subject |
Re: st: How to append two columns |

Date |
Thu, 4 Sep 2008 12:36:44 +0000 (GMT) |

Thanks Johannes and Ashim. The suggestions were great. I thought there could be a command to just do this without going through manipulations. Regards John --- On Thu, 4/9/08, Johannes Geyer <[email protected]> wrote: > From: Johannes Geyer <[email protected]> > Subject: Re: st: How to append two columns > To: [email protected] > Date: Thursday, 4 September, 2008, 12:53 PM > 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 > > ****************************** > > Johannes > > > [email protected] schrieb am 04/09/2008 > 11:36:48: > > > A crude way would be to multiply the 1st column by 10 > and add the 2nd > > column to it ? > > > > Ashim > > > > On Thu, Sep 4, 2008 at 3:03 PM, John Ataguba > <[email protected]> > wrote: > > > Dear members, > > > > > > 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 > > > > > > Any suggestion will be appreciated. > > > > > > Regards > > > John > > > > > > > > > > > > > > > * > > > * 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/ > > * > * 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" <[email protected]>

**References**:**Re: st: How to append two columns***From:*Johannes Geyer <[email protected]>

- Prev by Date:
**RE: st: Interpreting A Granger Causality Test** - Next by Date:
**st: RE: Changing property of a variable into number** - Previous by thread:
**Re: st: How to append two columns** - Next by thread:
**RE: st: How to append two columns** - Index(es):

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