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 is the one statement to set the criteria of data that can be coded in any step? : Sas programming
Mention common programming errors committed in sas ?
what are some good sas programming practices for processing very large data sets? : Sas programming
Name some categories in sas 9? : sas-grid-administration
What are the ways in which macro variables can be created in sas programming?
how to debug and test the sas program? : Sas-administrator
what is information maps?
Give some examples where proc report’s defaults are different than proc print’s defaults?
Explain translate function?
how do you want missing values handled? : Sas programming
What are the advantages of using sas?
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
do you prefer proc report or proc tabulate? Why? : Sas programming
What will calendar procedure do?
Describe crosslist option in tables statement?