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?
Inez
----- Original Message -----
From: Nick Cox <[email protected]>
Date: Wednesday, October 5, 2005 11:47 am
Subject: st: RE: RE: Changes of the dataset
> In your case, make sure that the identifier is of -long- type.
>
> . gen long newid = _n
>
>
> Nick
> [email protected]
>
> > -----Original Message-----
> > From: [email protected]
> > [mailto:[email protected]]On Behalf Of Nick Cox
> > Sent: 05 October 2005 10:33
> > To: [email protected]
> > Subject: st: RE: Changes of the dataset
> >
> >
> > 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]
> >
> > I.A.C. van de Snepscheut
> >
> > > I have a problem with my dataset. It is very huge, almost
> 400000
> > > lines. I want to change my dataset. It is sort of
> > transposing a very
> > > big matrix. But the difference is that the columns with the
> > same must
> > > be put together. To be clear is here a table how the
> > situation is in
> > > small:
> > >
>
> *
> * 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/
