Bioequivalence and Bioavailability Forum • geomean() in SAS

geomean() in SAS - crap [Software]

posted by d_labes – Berlin, Germany, 2017-02-14 16:39 (2951 d 13:59 ago) – Posting: # 17057
Views: 11,070

Dear Helmut, dear David,

❝ THX for enlightening me! Since I’m not equipped with 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:

SAS: Calculation of Geometric Mean arl_stat 2017-02-13 06:58 [Software]
- geomean() Helmut 2017-02-13 11:02
  - geomean() DavidManteigas 2017-02-13 16:17
    - geomean() Helmut 2017-02-14 14:06
      - geomean() in SAS - crapd_labes 2017-02-14 15:39
        
        geomean() in SAS - crap DavidManteigas 2017-02-15 10:50
        
        geomean() in SAS - crap ElMaestro 2017-02-15 11:21
        
        geomean() in SAS - crap DavidManteigas 2017-02-15 13:06
        
        Efficiency – who cares? Helmut 2017-02-15 14:26
        
        Efficiency – who cares? nobody 2017-02-15 15:22
        Efficiency – who cares? DavidManteigas 2017-02-15 16:12
        
        Efficiency – who cares? Helmut 2017-02-15 16:39
        
        Big money d_labes 2017-02-15 13:19