You understood my problem very well the first time, your output was
exactly what I wanted to have. Only I made my example a litte bit
simpler with less variables. You must think of the same situation only
the variables are not only price colour age id and buyer, but also a
couple of other variables (in total something like 30 variables). I
put all my variables between the brackets after i (just like you did)
and than stata gave an error. The number of variabeles is too high.
Than I tried and the maximum number of variables appeared to be 10, so
that is a problem. Now my question was do you have a solution for this
problem?
Inez
----- Original Message -----
From: n j cox <[email protected]>
Date: Wednesday, October 5, 2005 1:26 pm
Subject: Re: Re: st: RE: RE: Changes of the dataset
> 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/
>
*
* 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/
