Sorry, I thought that I understood what your problem was.
Now that you have changed the problem to this vaguer
one I don't have a clear enough picture to advise, except
in a backwards manner: if your data don't allow a -reshape-
solution, that may not really be a good idea.
It seems entirely possible that your original data structure
may in fact be best overall for what you want to do. You
just need to get fluent with -by:-, -collapse- and some other
commands.
Nick
[email protected]
I.A.C. van de Snepscheut
Hi Nick
Thanx for your quick reaction. But now I have the following problem: I
have too many variables. The maximum in this command is 10 and I have
many more variables. Can I do it a number of times?
Nick Cox
> > This looks like a -reshape- to me.
> >
> > . l
> >
> > +-----------------------------------+
> > | buyer price colour age id |
> > |-----------------------------------|
> > 1. | X 10 Yellow 12 1 |
> > 2. | X 10 Red 16 2 |
> > 3. | Y 12 Red 16 2 |
> > 4. | Z 13 Red 16 2 |
> > 5. | Z 15 Blue 4 3 |
> > |-----------------------------------|
> > 6. | Y 80 Green 1 4 |
> > 7. | H 6 White 20 5 |
> > 8. | H 10 White 20 5 |
> > 9. | X 14 Red 16 2 |
> > +-----------------------------------+
> >
> > . gen newid = _n
> >
> > . reshape wide price, i(newid id colour age) j(buyer) string
> > (note: j = H X Y Z)
> >
> > Data long -> wide
> > --------------------------------------------------------------
> > ---------------
> > Number of obs. 9 -> 9
> > Number of variables 6 -> 8
> > j variable (4 values) buyer -> (dropped)
> > xij variables:
> > price -> priceH priceX
> > ... priceZ
> > --------------------------------------------------------------
> > ---------------
> >
> > . renpfix price
> >
> > . drop newid
> >
> > . l
> >
> > +---------------------------------------+
> > | colour age id H X Y Z |
> > |---------------------------------------|
> > 1. | Yellow 12 1 . 10 . . |
> > 2. | Red 16 2 . 10 . . |
> > 3. | Red 16 2 . . 12 . |
> > 4. | Red 16 2 . . . 13 |
> > 5. | Blue 4 3 . . . 15 |
> > |---------------------------------------|
> > 6. | Green 1 4 . . 80 . |
> > 7. | White 20 5 6 . . . |
> > 8. | White 20 5 10 . . . |
> > 9. | Red 16 2 . 14 . . |
> > +---------------------------------------+
> >
> > See [D] reshape and the FAQ on reshape.
> >
> > Nick
> > [email protected]
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
