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

From |
"Martin Weiss" <martin.weiss1@gmx.de> |

To |
<statalist@hsphsun2.harvard.edu> |

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

Date |
Wed, 8 Apr 2009 17:47:55 +0200 |

<> Quang should be able to adapt Sergiy`s convenient solution to his needs. Note that it is not strictly necessary to do this with a -tempfile- in case you are uncomfortable with it. Just -save- it to a permanent file then. HTH Martin -----Ursprüngliche Nachricht----- Von: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Sergiy Radyakin Gesendet: Mittwoch, 8. April 2009 17:42 An: statalist@hsphsun2.harvard.edu Betreff: Re: st: AW: How to add the same block of data to every individual 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/ * * 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/

**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: AW: How to add the same block of data to every individual** - Next by Date:
**Re: st: RE: Re: local macro with if qualifier** - Previous by thread:
**Re: 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 |