Answer Posted / singh.naveen409@gmail.com
There are some various kinds of aggregate functions, which
we have
like**************
AVG()=Average
COUNT()=Numbers of rows
FIRST()=First value
LAST()=Last Value
MAX()=Maximum value from rows
MIN()=Minimum Value from rows
SUM()=Total
Aggregate function which use to visualize the answer in
single value from tables value.
And Aggregate function use in sql with "HAVING" and where
condition.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what does the run statement do? : Sas programming
what is treatment emergent events and treatment emregent adverse event
What do the PUT and INPUT functions do?
Describe the ways in which you can create macro variables?
what is program data vector? : Sas-administrator
What does P-value signify about the statistical data?
What is the difference between match merge and one to one merge?
what are input dataset and output dataset options? : Sas programming
What are the differences between proc means and proc summary?
What is your favorite all time computer book? Why?
What is the general format of function in sas? : sas-grid-administration
how would you create multiple observations from a single observation? : Sas programming
What are SAS/ACCESS and SAS/CONNECT?
Give some examples where proc report’s defaults are same as proc print’s defaults?
Explain how you can debug and test your SAS program?