Re: st: Errors in egen, total()

[Dan Blanchette <dan.blanchette@duke.edu>]

floats have about 7 digits of accuracy so I think that's what
you're running into with rev = 28536717

Here's the documentation on data types:
http://www.stata.com/help.cgi?datatype

Try:
 . recast long rev

as long has up to 9 digits of accuracy.

Dan Blanchette
Research Associate
Center for Entrepreneurship and Innovation
Duke University's Fuqua School of Business
dan.blanchette@duke.edu

> ------------------------------
>
> Date: Sat, 12 Dec 2009 22:19:30 -0600
> From: "Mike Kim" <kalisperos@gmail.com>
> Subject: st: Errors in egen, total()
>
> Hello all,
>
> I used "egen total()" to create "cumrev" like the following, but if there is 
> only one week per title, total gives a slightly lower number than the 
> original number in some cases (1 or 2 lower). Any idea about why it produces 
> different numbers?
>
> bys title week: egen cumrev=total(rev)
>
> title   week    rev                 cumrev
> A       707     28536717     28536716
> A       708     10                   30
> A       708     20                   30
> B        801    .....
> ......
>
> Thank you,
> Mike.
*
*   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/