Re: stddev returns 0 when there is one row

Поиск
Список
Период
Сортировка
От Murthy Kambhampaty
Тема Re: stddev returns 0 when there is one row
Дата
Msg-id 2D92FEBFD3BE1346A6C397223A8DD3FC0921FC@THOR.goeci.com
обсуждение исходный текст
Ответ на stddev returns 0 when there is one row  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
Since you mentioned SAS, lookup the documentation for PROC MEANS, the FREQ
statement ...nolan@celery.tssi.com writes:
>I guess I don't understand the point of the count(*) parameter
Since you mention SAS, lookup the documentation for PROC MEANS, the FREQ
statement ...

"specifies a numeric variable whose value represents the frequency of the
observation. If you use the FREQ statement, the procedure assumes that each
observation represents n observations, where n is the value of variable. If
n is not an integer, the SAS System truncates it. If n is less than 1 or is
missing, the procedure does not use that observation to calculate
statistics.

The sum of the frequency variable represents the total number of
observations."


В списке pgsql-general по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: Documentation
Следующее
От: Joe Conway
Дата:
Сообщение: Re: stddev returns 0 when there is one row