The MEDIAN function is documented in "What's New in Base SAS^® 9.0, 9.1, and 9.1.3 Language."

The syntax for using this function is shown below:

Prior to SAS 9.4, if the Base SAS MEDIAN function is used in the SQL procedure, it returns only the median value for columns referenced in the function for the current row.

Beginning in SAS 9.4, PROC SQL supports the median aggregate function. When more than one argument is used within an SQL aggregate function, the function is no longer considered to be an SQL aggregate or summary function. If a Base SAS function with a similar name exists, then PROC SQL executes this Base SAS function, and the results that are returned are based on the values for the current row. For more information about the usage of the MEDIAN function, see the "summary-function" section in the SAS^® 9.4 SQL Procedure User's Guide, Third Edition.

Operating System and Release Information