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

st: Time taken for reshape command


From   "Subhankar Nayak" <nayak@bellsouth.net>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Time taken for reshape command
Date   Tue, 18 May 2004 12:05:14 -0400

Hello all,

The "reshape" command that I am using takes an extremely long time and I am
not sure whether this is normal.
Let me mention the details.

I have 1000 observations and 926 variables.

Variable: "ID"  takes values from 1 through 1000. (denoting 1000 companies)
Variable  "Y"   is a specific corporate value
924 variables: X1 through X924 denote the 924 past stock prices.

I am reshaping it in the long format into 924000 observations and 3
variables (ID,Y,X) using
reshape long X, i(ID) j(DAYS)

This single command takes 10-12 minutes to process.
Is this normal?

Thanks.


*
*   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