Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Aggregate functions in SQL ?
- 2 Answers
- 7972 Views
- AON, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / solasa
You can use aggregate (or summary) functions to summarize
the data in your tables. These functions can act on
multiple columns in a row or on a single column across rows.
Avg average of values •
NMiss number of missing values
Count number of non-missing values
• Prt probability of a greater absolute value of Student’s t
. CSS corrected sum of squares.
Freq (same as Count)
Nmiss,STDERR,MEan,Min,MAx etc
use this link:
http://www2.sas.com/proceedings/sugi30/257-30.pdf.
from
Solasa
solasa@in.com
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / 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 |
How do I CREATE an external dataset with sas code? I would like to create within a sascode a non-exsistent textfile on the host. So I am not forced to create the file befor filling it.
What is your weekness? I am confuse what to say about this question. so can u give some answer which can be yur strenght.
Explain why double trailing @@ is used in input statement?
what is the difference between proc means and proc tabulate?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
what is the formula to measure Baseline
Describe the function and utility of the most difficult SAS macro that you have written?
What is the order of application for output data set options, input data set options and SAS statements?
what are the types of interactive display types? : Sas-bi
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
i have a macro variable var1,var2. i want titles for the each macro variable separately? how it is possible?
I need level 2 to 5 sas using companies in india
Teradata 
