How to change scientific notation into standard format?

[Muhammad Abid Shahzad]

Hello all, can anyone please guide me, how can I get rid of scientific notation in the summary down below?
I am interested in the full formatted number in the summary.



. sum fungicidesandbactericides




Variable | Obs Mean Std. Dev. Min Max

-------------+---------------------------------------------------------

fungicides~s | 56 5757572 1.03e+07 66163 3.89e+07

[Felix Bittmann]

format fungicidesandbactericides %10.5f
sum fungicidesandbactericides, format
help format

See the manual entry for more information on the available formats to use.

[Muhammad Abid Shahzad]

Thanks Felix Bittmann . I tried the commands but it gave the same output.

[Felix Bittmann]

Mh I see, this does indeed not work. I am not sure why summarize does not take the format with the format option. Maybe someone else can explain how to interpret the format option from the documentation. As a quick work around you could use something like

egen meanval = mean(varname)
format meanval %25.0g
list meanval in 1

As long as you are happy to get the mean.


EDIT: Apparently, the solution is to use tabstat instead.

tabstat varname, s(mean) format(%25.0g)

[Nick Cox]

I would change the units: just divide by 1 million.