Carry Croghan/RTP/USEPA/US@EPA wrote:
> I have a couple of questions concerning geomean.
>
> 1. I had thought that geomean was available with proc means and/or
proc
> summary. Both geomean and gmean as a keyword have produced an error.
> Is geomean available as an additional stat? If so, what is the
keyword?
>
> 2. The note in SAS help says that there is a fuzz factor used for when
> the variable is 0 or close to 0. Does any one know what that fuzz
> factor is or what close to 0 is defined as?
>
>
> I guess technically this is four questions in a couple of areas.
Hey, you work for ORD too! Small world.
Okay:
[1] No and no. Geometric means aren't part of the keyword set. It
isn't
available as an additional stat.
[2] 'Close to zero' is what you get to define if you change the fuzz
factor.
If you want the geometric means of variables X1, X2, ... you can get
them
through a sneaky trick I learned from an old post of Nat Wooding:
proc sql noprint;
create table YourGeoMeans as
select exp(mean(log(x1))) as g_x1,
exp(mean(log(x2))) as g_x2,
.....
from YourData;
quit;
There's an old post of mine in the SASL archives which has even more on
building geometric (and other) means:
http://www.listserv.uga.edu/cgibin/wa?A2=ind0109C&L=sasl&P=R18556
If you don't use the SASL archives, you should. They're a great
resource.
So... Why do you need to compute geometric means anyway?
David

David Cassell, CSC
Cassell.David@epa.gov
Senior computing specialist
mathematical statistician
