geomean() in SAS - crap [Software]

posted by d_labes  – Berlin, Germany, 2017-02-14 16:39 (2599 d 17:43 ago) – Posting: # 17057
Views: 10,050

Dear Helmut, dear David,

❝ THX for enlightening me! Since I’m not equipped with [image] I didn’t expect that it is sooo complicated. ;-)


It is much more complicated as sooo, add some more ooooo :cool:.
You can use geomean() in SQL queries as David wrote,
proc SQL;
  select geomean(column) from data;
quit;

but it doesn't do anything, or at least not what one would expect, but gives me the column back, unchanged, and produces a warning:
WARNING: The GEOMEAN function has been called with only one argument. However, it is not an SQL
         aggregate function, and this call will not cause SQL aggregation.

What? Why to hell?

I don't understand why the SAS people have created such a crippled implementation of the geometric mean, only useful in a data step to calculate the geometric mean over more then one variable, row-wise. And nothing else.
Forget it :not really:! You have to roll your own.

Regards,

Detlew

Complete thread:

UA Flag
Activity
 Admin contact
22,957 posts in 4,819 threads, 1,636 registered users;
107 visitors (0 registered, 107 guests [including 6 identified bots]).
Forum time: 10:23 CET (Europe/Vienna)

With four parameters I can fit an elephant,
and with five I can make him wiggle his trunk.    John von Neumann

The Bioequivalence and Bioavailability Forum is hosted by
BEBAC Ing. Helmut Schütz
HTML5