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

what versions of sas have you used (on which platforms)? : Sas programming

1133


Do you need to rearrange the order of the data for the report?

2360


what is the Population you used in your project, is it ITT or PP?

2805


Enlist the syntax rules followed in sas statements.

1129


What system options would you use to help debug a macro? : sas-macro

1149


how do the in= variables improve the capability of a merge? : Sas programming

1484


What does proc print, and proc contents are used for?

1221


what is hierarchy flattening? : Sas-di

1135


What is program data vector (pdv) and what are its functions?

1318


Mention what is PROC in SAS?

1113


What are the different types of sas functions?

1363


Where do you use proc means over proc freq?

1188


What is a put statement?

1272


why a stop statement is needed for the point= option on a set statement?

1133


what are informats in sas? : Sas-administrator

1150