Re: stddev returns 0 when there is one row - Mailing list pgsql-general

From Murthy Kambhampaty
Subject Re: stddev returns 0 when there is one row
Date
Msg-id 2D92FEBFD3BE1346A6C397223A8DD3FC0921FC@THOR.goeci.com
Whole thread Raw
In response to stddev returns 0 when there is one row  (Bruno Wolff III <bruno@wolff.to>)
List 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 by date:

Previous
From: Joe Conway
Date:
Subject: Re: Documentation
Next
From: Joe Conway
Date:
Subject: Re: stddev returns 0 when there is one row