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

Differentiate between sas functions and sas procedures.

1146


What is the use of %include statement?

995


If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1415


If a variable contains only numbers, can it be a character data type?

1033


How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1623


To what type of programms have you used scratch macros?

2526


Tell e how how dealt with..

2169


What are the default statistics that proc means produce?

967


Explain what is data step?

1130


Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2354


How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1478


What are the data types in sas?

1002


What would you change about your job?

2332


Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2199


How long can a macro variable be? A token? : sas-macro

1155