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
Do you know the features of sas?
Explain the special input delimiters used in sas programming.
How we can call macros with in data step? : sas-macro
how does sas handle missing values in sort order? : Sas programming
What is the use of %include statement?
Name any two sas spawners? : sas-grid-administration
What is maximum number of rows and cols can be handled in SAS?
how will you locate the sas platform applications? : Sas-bi
How to limit decimal places for the variable using proc means?
how the sas basic syntax style described? : Sas-administrator
What are all the problems you faced while validating tables and reports?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
What’s the difference between var b1 – b3 and var b1 — b3?
How to specify variables to be processed by the freq procedure?
For what purpose would you use the RETAIN statement?