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

 From Quang Nguyen 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 05:31:52 -1000

```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/
```