Min and Max in Sum

[Jade Li]

Dear Stata Users,

I am generating a table of descriptive statistics by using

sum

. However, it gives me the min and max as well. How can I ask Stata not to show these two statistics? It is a requirement as I am using confidential data.

Thank you
JL

[Maarten Buis]

. sysuse auto
(1978 automobile data)

. table () (), stat(mean price) stat(mean mpg) stat(mean weight) ///
>              stat(sd price) stat(sd mpg) stat(sd weight)

------------------------------
Mean               |          
  Price            |  6165.257
  Mileage (mpg)    |   21.2973
  Weight (lbs.)    |  3019.459
Standard deviation |          
  Price            |  2949.496
  Mileage (mpg)    |  5.785503
  Weight (lbs.)    |  777.1936
------------------------------

. collect layout (var) (result)

Collection: Table
      Rows: var
   Columns: result
   Table 1: 3 x 2

----------------------------------------------
              |      Mean   Standard deviation
--------------+-------------------------------
Price         |  6165.257             2949.496
Mileage (mpg) |   21.2973             5.785503
Weight (lbs.) |  3019.459             777.1936
----------------------------------------------

[Jade Li]

Thank you, Maarten,

I tried this code

logout, clear excel save(first_results) replace:  stat (mean var1) stat (mean var2) stat (mean var3)   stat (sd var1) stat (sd var2) stat (sd var3)

Stata gave me this error

. logout, clear excel save(first_results) replace:  stat (mean var1)
> stat (mean var2) stat (mean var3)   stat (sd var1) stat (sd var2) s
> tat (sd var3)

command stat is unrecognized
r(199);

end of do-file

r(199);

.

[Carlo Lazzaro]

Jade:
you inadvertertently missed the first part of Maarten's helpful code:

 
 table () (),

[Jade Li]

Ah right! My bad, sorry. Thank you Carlo.