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
why a stop statement is needed for the point= option on a set statement?
what are the categories that sas informats are used to the place the data? : Sas-administrator
what are informats in sas? : Sas-administrator
Why and when do you use proc sql?
Explain the special input delimiters used in sas programming.
how to change the execute of macro
what is business intelligence? : Sas-bi
describe how to adjust the performance of data integrator? : Sas-di
How to create an external dataset with sas code?
Describe a time when you were really stuck on a problem and how you solved it?
describe about metadata object? : Sas-di
Define run-group processing?
what is star schema? : Sas-di
What is slibref?
What do the mod and int function do? : Sas programming