Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are the Aggregate functions in SQL ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

for what purpose would you use the retain statement? : Sas programming

1076


What is the role of sas grid administrator? : sas-grid-administration

1278


What is the order of application for output data set options, input data set options and SAS statements?

1544


If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

1052


What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1149


Explain the main difference between the sas procedures and functions? : Sas-administrator

1060


How can I remove header from output data set?

2613


what is the use of proc sql? : Sas programming

1123


How you can read the variables that you need?

1118


Explain the special input delimiters used in sas programming.

1000


how to remove duplicates using proc sql?

1138


What is substr function?

1174


Why and when do you use proc sql?

1237


what is information maps?

2213


What is the difference between %put and symbolgen? : sas-macro

1229