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
What is the difference between reading data from an external file and reading data from an existing data set?
What is the difference between the proc sql and data step?
State the difference between INFORMAT and FORMAT ?
How to create an external dataset with sas code?
what is business intelligence? : Sas-bi
explain the key concept of sas? : Sas-administrator
how can you create zero observation dataset? : Sas programming
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
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
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
Differences between where and if statement?
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
what is factor analysis? : Sas-administrator
explain the concepts and capabilities of business object? : Sas-bi
describe how to adjust the performance of data integrator? : Sas-di
