When will median function be supported in Proc SQL?

[KevinQin]

Hi,
Does SAS plan to support median in 9.3?

[Cynthia_sas]

Hi:
Did median become part of the ANSI standard? I searched and didn't find anything. Although it's possible that several vendor-specific SQLs might have median, my understanding was that with SAS you could get median at the row level, but to get median for an entire column across a table, you would need to use one of the other SAS procedures that give median.

Here are some relevant links to the documentation:
http://support.sas.com/kb/14/659.html
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a002473705.htm
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a002473699.htm

cynthia

[KevinQin]

Cynthia,
Thank you for the information.
It make sense.

-Kevin