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 are the 3 components in sas programming?

1195


Which are the statements whose placement in the data step is critical?

1266


What can you learn from the SAS log when debugging?

1385


What is the difference between where and if statement?

1116


What are the different versions of sas that you have used until now? : sas-grid-administration

1340


how can you create zero observation dataset? : Sas programming

1149


How to convert a numeric variable to a character variable?

1210


What is the work of tranwrd function?

1248


How to read an input file in sas?

1144


If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

1165


What is the maximum length of the macro variable?

1181


for report generation which one you used proc report or data_null_?

7792


what are all the reports you generated in your recent project?

2199


Mention few capabilities of sas framework.

1193


what are validation tools that are used in sas? : Sas-administrator

1059