Reply To: Asdoc tabulate–showing statistics, rounding decimals

[Prerak]

#4144

Dear Sir,

Please find the example attached below.

sysuse auto, clear
table make foreign, c(mean price) row 

The ideal output should have
 
   Renault Le Car |              3,895
           Subaru |              3,798
    Toyota Celica |              5,899
   Toyota Corolla |              3,748
    Toyota Corona |              5,719
        VW Dasher |              7,140
        VW Diesel |              5,397
        VW Rabbit |              4,697
      VW Scirocco |              6,850
        Volvo 260 |             11,995

            Total |  6,072.4   6,384.7

But when I use

asdoc table make foreign, c(mean price) row save(abcd)

Renault Le Car	| 	        3895
Subaru		|               3798
Toyota Celica	|	        5899
Toyota Corolla	|	        3748
Toyota Corona	|	        5719
VW Dasher	|	        7140
VW Diesel	|	        5397
VW Rabbit	|	        4697
VW Scirocco	|	        6850
Volvo 260	|	        11995

Total	        | 315766        140463

Here, asdoc is summing up all values in corresponding columns and giving that sum value in Total instead of actual values from the output window.

Please help me with the concern mentioned here.

Thank you for your time.

• This reply was modified 3 years, 2 months ago by Attaullah Shah.
• This reply was modified 3 years, 2 months ago by Attaullah Shah.