Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: RE: Changes of the dataset


From   "I.A.C. van de Snepscheut" <Inez.vandeSnepscheut@student.uva.nl>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: RE: Changes of the dataset
Date   Wed, 05 Oct 2005 12:14:47 +0200

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 <n.j.cox@durham.ac.uk>
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 
> n.j.cox@durham.ac.uk 
> 
> > -----Original Message-----
> > From: owner-statalist@hsphsun2.harvard.edu
> > [mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of Nick Cox
> > Sent: 05 October 2005 10:33
> > To: statalist@hsphsun2.harvard.edu
> > 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 
> > n.j.cox@durham.ac.uk 
> > 
> > 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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index