[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
Quang Nguyen <quangn@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: AW: How to add the same block of data to every individual |

Date |
Wed, 8 Apr 2009 07:03:28 -1000 |

Thanks Martin, Serigy, Nick, and Pavrila. Serigy's suggestion on joinby is really beautiful. Many thanks! On Wed, Apr 8, 2009 at 5:41 AM, Sergiy Radyakin <serjradyakin@gmail.com> wrote: > A better way would be to use -joinby-. > > clear > input byte id byte x > 1 4 > 2 6 > 3 7 > end > generate dummy=1 > preserve > clear > input str1 y byte z > a 7 > b 8 > c 9 > end > gen dummy=1 > tempfile mrg > save `"`mrg'"' > restore > joinby using `"`mrg'"' > drop dummy > sort id y > list, sepby(id) > > Best wishes, > Sergiy Radyakin > > PS: variable dummy (substitute any name, which is not in either of > your datasets) is needed here because otherwise Stata complains that > there is no common variable to join by. Perhaps it is a sensible > default behaviour, when there is nothing to join by, just attach one > dataset to each observation of the other?? > > > On Wed, Apr 8, 2009 at 11:31 AM, Quang Nguyen <quangn@gmail.com> wrote: >> Thanks Martin for such an excellent solution. Actually, the block of >> data is a (6x35) matrix. Can you suggest a somewaht better procedure? >> >> Many thanks! >> >> >> On Wed, Apr 8, 2009 at 5:14 AM, Martin Weiss <martin.weiss1@gmx.de> wrote: >>> >>> <> >>> >>> It really depends where you want to take this exercise next, but here is a >>> shot at the prob: >>> >>> ************* >>> clear* >>> >>> inp id x >>> 1 4 >>> 2 6 >>> 3 7 >>> end >>> >>> expand 3 >>> >>> bys id: g str1 y="a" >>> by id: replace y="b" if _n==2 >>> by id: replace y="c" if _n==3 >>> by id : egen float z = seq(), from(1) to(3) block(1) >>> >>> l, noo sepby(id) >>> ************* >>> >>> >>> >>> HTH >>> Martin >>> >>> -----Ursprüngliche Nachricht----- >>> Von: owner-statalist@hsphsun2.harvard.edu >>> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Quang Nguyen >>> Gesendet: Mittwoch, 8. April 2009 17:00 >>> An: statalist@hsphsun2.harvard.edu >>> Betreff: st: How to add the same block of data to every individual >>> >>> Dear All: >>> >>> Suppose I have the following data set: >>> >>> id x >>> 1 4 >>> 2 6 >>> 3 7 >>> .................. >>> >>> and a "data block" as follows: >>> >>> y z >>> a 7 >>> b 8 >>> c 9 >>> >>> Do you know how I can add this data block to every individual in the >>> idividial data set. After adding, the new data set will look like the >>> following: >>> >>> id x y z >>> 1 4 a 7 >>> 1 4 b 8 >>> 1 4 c 9 >>> 2 6 a 7 >>> 2 6 b 8 >>> 2 6 c 9 >>> ---------------------------- >>> >>> Many thanks! >>> >>> >>> >>> -- >>> "My father gave me the greatest gift anyone could give another person, >>> he believed in me." - Jim Valvano >>> * >>> * 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/ >>> >> >> >> >> -- >> "My father gave me the greatest gift anyone could give another person, >> he believed in me." - Jim Valvano >> >> * >> * 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/ > -- "My father gave me the greatest gift anyone could give another person, he believed in me." - Jim Valvano * * 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: AW: How to add the same block of data to every individual***From:*Joseph McDonnell <jockmcdock@gmail.com>

**References**:**st: How to add the same block of data to every individual***From:*Quang Nguyen <quangn@gmail.com>

**Re: st: AW: How to add the same block of data to every individual***From:*Quang Nguyen <quangn@gmail.com>

**Re: st: AW: How to add the same block of data to every individual***From:*Sergiy Radyakin <serjradyakin@gmail.com>

- Prev by Date:
**Re: st: cluster option in qreg** - Next by Date:
**RE: st: spatial weighting matrix** - Previous by thread:
**AW: st: AW: How to add the same block of data to every individual** - Next by thread:
**Re: st: AW: How to add the same block of data to every individual** - Index(es):

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