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 substr function?
What is the sas data set? : sas-grid-administration
what is sas metadata repository? : Sas-bi
What is a put statement?
What is SAS?
where to use sas business intelligence? : Sas-bi
Explain proc sort?
how can you import .csv file in to sas? : Sas programming
why is a stop statement needed for the point=option on a set statement? : Sas programming
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
How would you determine the number of missing or nonmissing values in computations?
What are the parameters of scan function?
for what purpose would you use the retain statement? : Sas programming
How do you add a number to a macro variable? : sas-macro
How you can read the variables that you need?