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 method to debug and test your SAS program?

731


How would you identify a macro variable? : sas-macro

543


What is the purpose of trailing @ and @@? How do you use them?

619


Mention what are the data types does SAS contain?

703


what is the difference between nodup and nodupkey options? : Sas programming

631






how do you pull data from equifax?tell me the process?

1390


How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1178


What are the table names in oracle database...?

2265


what other sas products have you used and consider yourself proficient in using? : Sas programming

693


How do you test for missing values?

1065


how to change the execute of macro

1688


what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

743


If you could design your ideal job, what would it look like?

2388


I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

2274


What are the different servers in sas? : sas-grid-administration

611