Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain data step in SAS
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
what is the use of proc contents and proc print in sas? : Sas-administrator
What is the role of sas grid administrator? : sas-grid-administration
Describe the function and untility of the most difficult SAS macro that you have written.
why a stop statement is needed for the point= option on a set statement?
How would you include common or reuse to be processed along with your statements?
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
name the scheduler for scheduling job and explain the scheduler? : Sas-di
What is the purpose of _character_ and _numeric_?
How do you delete duplicate observations in sas?
how would you determine the number of missing or nonmissing values in computations? : Sas programming
Give some examples where proc report’s defaults are same as proc print’s defaults?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
How to create a permanent sas data set?
