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:28:00 +0100

I believe that is in fact the best way so long the PersonNo really is a
digit between 0 and 9. That might be guessed from the example but is not
explicit as a rule. But pay attention to variable type. 

Otherwise -egen, concat()- offers a more robust solution followed by
-destring- if desired. 

Nick 
n.j.cox@durham.ac.uk 

Ashim Kapoor

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