> Instead of -tabulate-, use -table-.
thanks for the suggestion, i tried it as follows
. table catag ined, format(%12.0gc) cellwidth(12)
but it doesn't work; your solution seems to depend on iweight
even if it had worked, it would have solved the
display bug of -tabulate- at a cost: where my -tabulate- took 4
seconds the -table- took 193.
since i use -tabulate- to peruse the data from different angles i
can't afford to wait 3 minutes for every crosstab
perhaps the good people at statacorp could fix -tabulate-'s display of
(large) numbers?
thanks nick for looking into this.
regards, edwin
With a set-up
> close to yours, although you may not be using weights,
> I got this by a mixture of peeking inside the code
> and fumbling around:
>
> . table cataggr ined [iw=freq], row col format(%12.0gc) cellwidth(12)
>
> ----------------------------------------------------------
> | ined
> cataggr | 0 1 Total
> ----------------+-----------------------------------------
> employed | 1,643,604 171,412 1,815,016
> inactivity | 491,819 173,642 665,461
> lost | 812,882 216,943 1,029,825
> on education | 489,318 307,425 796,743
> on program | 629,950 152,585 782,535
> part-t unempl | 120,828 16,760 137,588
> registered empl | 310,365 88,014 398,379
> unemployed | 1,031,164 460,069 1,491,233
> . | 8,577,229 5,562,875 14,140,104
> |
> Total | 14,107,159 7,149,725 21,256,884
> ----------------------------------------------------------
>
> The interdependence of -format()- and type of weight
> does not appear to be documented.
>
> Nick
> [email protected]
>
> Edwin Leuven
>
> > when doing a cross tabulate, stata messes up the display of
> > the numbers by
> > omitting the thousands separator and making the table
> > difficult to read:
> >
> > | ined
> > cataggr | 0 1 | Total
> > ----------------+----------------------+----------
> > unemployed | 1031164 460,069 | 1491233
> > part-t unempl | 120,828 16,760 | 137,588
> > on program | 629,950 152,585 | 782,535
> > registered empl | 310,365 88,014 | 398,379
> > employed | 1643604 171,412 | 1815016
> > on education | 489,318 307,425 | 796,743
> > lost | 812,882 216,943 | 1029825
> > inactivity | 491,819 173,642 | 665,461
> > . | 8577229 5562875 | 14140104
> > ----------------+----------------------+----------
> > Total | 14107159 7149725 | 21256884
> >
> > is there a way to make stata behave as it should: in a
> > consistent manner
> > and then preferably with separators everywhere?
>
> *
> * 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/
>
--
Edwin Leuven
Department of Economics
University of Amsterdam
Roetersstraat 11
1018 WB Amsterdam
the Netherlands
tel: +31 20 525 5241
fax: +31 20 525 4310
http://www.fee.uva.nl/scholar/mdw/leuven
*
* 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/
