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 sas application server? : Sas-di

529


If money were no object, what would you like to do?

2678


In SAS explain which statement does not perform automatic conversions in comparisons?

790


What is the command used to find missing values?

583


Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

1575






Explain how you can debug and test your SAS program?

559


What are the differences between proc means and proc summary?

595


Explain the use of proc gplot? : sas-grid-administration

544


Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

1337


What is the basic structure of the SAS base program?

678


Describe crosslist option in tables statement?

701


describe about physical data integration? : Sas-di

553


How can you create a macro variable with in data step? : sas-macro

564


Explain what is SAS informats?

610


Have you ever used the SAS Debugger?

1201