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

What is a macro routine?

2368


What is the difference between %put and symbolgen? : sas-macro

942


Are you involved in writing the inferential analysis plan? Tables specifications?

3721


how would you determine the number of missing or nonmissing values in computations? : Sas programming

925


Mention the category in which sas informats are placed?

817


what do you mean by data staging area? : Sas-di

849


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

1951


What do the SAS log messages "numeric values have been converted to character" mean?

1121


What is data _null_?

913


how to change the execute of macro

1947


for report generation which one you used proc report or data_null_?

7172


Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1711


How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1330


What does proc print, and proc contents are used for?

832


what is sas metadata server? : Sas-di

856