| From: | Murthy Kambhampaty <murthy(dot)kambhampaty(at)goeci(dot)com> |
|---|---|
| To: | "'nolan(at)celery(dot)tssi(dot)com'" <nolan(at)celery(dot)tssi(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: stddev returns 0 when there is one row |
| Date: | 2003-04-21 18:08:18 |
| Message-ID: | 2D92FEBFD3BE1346A6C397223A8DD3FC0921FC@THOR.goeci.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Since you mentioned SAS, lookup the documentation for PROC MEANS, the FREQ
statement (dot)(dot)(dot)nolan(at)celery(dot)tssi(dot)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."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2003-04-21 18:14:55 | Re: stddev returns 0 when there is one row |
| Previous Message | Joe Conway | 2003-04-21 18:01:51 | Re: Documentation |