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

Enlist the syntax rules followed in sas statements.

845


What is the use of divide function?

796


What is the difference between order and group variable in proc report?

1127


Mention what are the data types does SAS contain?

913


what is data governance? : Sas-di

789


Explain the difference between informat and format with an example.

930


Describe the ways in which you can create macro variables?

852


Explain what is SAS informats?

829


What is program data vector (pdv) and what are its functions?

835


what is the difference between infile and input? : Sas-administrator

855


what is change analysis in sas di ? : Sas-di

795


how many types prompting framework can be broken down to? : Sas-bi

843


Describe the function and untility of the most difficult SAS macro that you have written.

1943


What are the applications primarily used by business analyst? : Sas-bi

775


what are input dataset and output dataset options? : Sas programming

805