ORACLE function corresponding to SAS's MEAN function

Posted on 2004-11-02
Last Modified: 2011-09-20
Can anybody please help me in finding out the function name in ORACLE which gives same result as SAS's MEAN() function.
e.g. In SAS,

Question by:sharada
    LVL 15

    Expert Comment

    SAS's MEAN is simply the arithmetic mean, or average, of a set of numbers. Oracle's AVG is the corresponding function.

    Author Comment

    Oracle's AVG function will be useful to me if I need to find out the MEAN or average of a column.

    But I have following statement in SAS
    If I need to convert this statement to Oracle, should I write
    LVL 15

    Accepted Solution

    Yes, if you are dealing with a list of values that would be the easiest way to do it.

    Author Comment

    Yes, I tried this yesterday and it worked.. thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now