Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Aggregate functions in SQL ?
- 2 Answers
- 8229 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 |
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
Could you please answers for this. 1.Code the tables statement for a single-level (most common) frequency. 2.Code the tables statement to produce a multi-level frequency.
What does the RUN statement do?
Differences between where and if statement?
In the flow of DATA step processing, what is the first action in a typical DATA Step?
How to display duplicate observations in data?
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
How do handle working under pressure?
Name and describe three SAS functions that you have used, if any?
What are the limitations for memory allocation for SAS variables
What are the prime responsibilities of data integration administrator? : Sas-di
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
Teradata 
