Great instincts, Tim. I was using outsheet but was also browsing the data within Stata beforehand & saw the problem there already. I guess the display format is used both in browse and by outsheet. As per your suggestion, I changed the display formats & now everything is copacetic. I guess my new question is how do collapse & egen pick display formats (because I just went with what Stata gave me)?
Thanks,
Eric
>How are you figuring out the values in your collapsed dataset?
>
>It sounds like you are using -outsheet- to output the data (or are
>displaying it using -list-). If so then the data is outputted using its
>display format. If your display format is %X.0g then it could write to
>the text file something like:
>1.045e+09
>Rather than:
>1,045,855,825
>
>To stop this behavior you need to change the display format of your
>variable to something like %12.0g.
>
>-Tim
>
--
===================================================
Eric G. Wruck
Econalytics
2535 Sherwood Road
Columbus, OH 43209
ph: 614.231.5034
cell: 614.330.8846
eFax: 614.573.6639
eMail: [email protected]
website: http://www.econalytics.com
====================================================
*
* 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/
