Bioequivalence and Bioavailability Forum • geomean() in SAS

geomean() in SAS - crap [Software]

posted by DavidManteigas – Portugal, 2017-02-15 11:50 (2626 d 05:16 ago) – Posting: # 17060
Views: 10,031

Dear d_labes,

You're absolutely right. Crappy implementation of SQL in SAS as usual, the function does not work even with a "group by" statement as ordinary arithmetic functions work. SAS "reads" data line by line and apply functions to each line. Therefore, this function seems even more useless than I actually thought.

Well, from my side I always use proc summary in log-transformed data to calculate geometric means and exponentiate the result. It's amazing how such a routinely used statistic is not avaliable as part of the "default" summary functions in SAS.

Complete thread:

SAS: Calculation of Geometric Mean arl_stat 2017-02-13 06:58
- geomean() Helmut 2017-02-13 11:02
  - geomean() DavidManteigas 2017-02-13 16:17
    - geomean() Helmut 2017-02-14 14:06
      - geomean() in SAS - crap d_labes 2017-02-14 15:39
        
        geomean() in SAS - crapDavidManteigas 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