Razzak's message about the LISTOF option piqued my interest.  I noticed that
STDEV and VARIANCE were listed as some of the aggregate functions.  Are
these new options that will be available in the upcoming in-line patch?  I
know they are available via the COMPUTE command.  That would be wonderful if
they were also going to be part of the SELECT command.  Part of my job is
doing statistical analysis.  I currently use AVG, MAXIMUM, and MINIMUM for
some of my analysis but then I have to use a loop to calculate the STDEV.
Or am I missing something?

Thanks

> The aggregate functions (AVG, COUNT, MAXIMUM, MINIMUM, STDEV, SUM,
> VARIANCE) used in SELECT commands now have a new member of their
> family called "LISTOF" which creates a text string of the values
> separated by the current comma delimiter character.


Mike Ramsour
Technology Department
AK Steel Coshocton Works
17400 SR 16
Coshocton, OH  43812-0190

Voice:  (740) 829-4340
FAX  :  (740) 829-4211

Reply via email to