geomean() in SAS - crap [Software]
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.
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 [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 - 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
- Efficiency – who cares? Helmut 2017-02-15 14:26
- Big money d_labes 2017-02-15 13:19
- geomean() in SAS - crap DavidManteigas 2017-02-15 13:06
- geomean() in SAS - crap ElMaestro 2017-02-15 11:21
- geomean() in SAS - crapDavidManteigas 2017-02-15 10:50
- geomean() in SAS - crap d_labes 2017-02-14 15:39
- geomean() Helmut 2017-02-14 14:06
- geomean() DavidManteigas 2017-02-13 16:17
- geomean() Helmut 2017-02-13 11:02