Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: Date: Sun, 7 Feb 2010 21:41:16 +0100


From   "Martin Weiss" <[email protected]>
To   <[email protected]>
Subject   st: RE: Date: Sun, 7 Feb 2010 21:41:16 +0100
Date   Sun, 7 Feb 2010 22:16:07 +0100

<>

So when you -trace- the execution of -reshape- with your problem in mind,
you can see that it is actually the limits of -tabulate- that bite here
(hence no entry for -reshape- in -help limits- which initially bewildered
me). 

According to -help limits-, the limits differ between -version-s. For my MP,
the limit is at 12,000 unique values. Your number exceeds all of the limits,
so you have to find a way around this along the lines of Kit`s suggestion.

HTH
Martin


-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Mark Baerthel
Sent: Sonntag, 7. Februar 2010 21:41
To: [email protected]
Subject: st: Date: Sun, 7 Feb 2010 21:41:16 +0100

Dear Stata Community,

I always get the error r(134) when I try to reshape!
What can I do ?
Anything conceptually wrong with my commands ?
>>
. sum

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
        date |     32494     14804.6    105.3298      14640      14973
      permno |     32494    65554.46    23142.46      10051      92866
         ret |     32494    .0081212    .1509227  -.8353909          3

. reshape wide permno, i(date) j(ret)
ret takes on too many values
r(134);
<<<

ret takes on too many values
r(134);


Thank you so much, 

Mark

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



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