What are the Aggregate functions in SQL ?

Answer Posted / solasa

You can use aggregate (or summary) functions to summarize
the data in your tables. These functions can act on
multiple columns in a row or on a single column across rows.

Avg average of values •
NMiss number of missing values
Count number of non-missing values
• Prt probability of a greater absolute value of Student’s t
. CSS corrected sum of squares.
Freq (same as Count)
Nmiss,STDERR,MEan,Min,MAx etc


use this link:
http://www2.sas.com/proceedings/sugi30/257-30.pdf.


from
Solasa
solasa@in.com

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between sum function and using “+” operator?

606


Explain proc sort?

673


What will calendar procedure do?

603


For what purpose would you use the RETAIN statement?

1047


What is the purpose of _character_ and _numeric_?

592






Name few SAS functions?

670


if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1169


what is the use of proc sql? : Sas programming

600


how will you locate the sas platform applications? : Sas-bi

586


what are all the reports you generated in your recent project?

1687


Explain append procedure?

636


What are common programming errors committed in sas

675


Did you used proc test? when?

1577


What function CATX syntax does?

693


what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

1689