st: Format summary table numbers with maximum of one decimal

[Christoph Schnelle <cs@inyourinterest.com.au>]

Dear Statalist,

I am trying to create a summary with N, mean and sd showing no decimal for = the integer (N) and exactly one decimal for mean and sd in Stata 13 and I a= m not succeeding.

The closest I came is with:

sysuse auto
tabstat mpg, by(foreign) stat(n mean sd) nototal format(%9.1g)

foreign |         N      mean        sd
---------+------------------------------
Domestic |        52        20       4.7
Foreign |        22        25       6.6
----------------------------------------

Other summary command don't support formatting as far as I know and 'format=  (%9.1f)' leads to N having a decimal.

tabstat mpg, by(foreign) stat(n mean sd) nototal format(%9.1f)

Summary for variables: mpg
     by categories of: foreign (Car type)

foreign |         N      mean        sd
---------+------------------------------
Domestic |      52.0      19.8       4.7
Foreign |      22.0      24.8       6.6
----------------------------------------

Is the fact that %9.1g shows no decimal for mean a bug or a feature?
Is there a way to achieve what I am looking for (zero decimals for integers= , one decimal for non-integer numeric)?

Warm Regards,

Christoph Schnelle

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/