When will median function be supported in Proc SQL?

KevinQin — Fri, 28 Aug 2009 09:08:51 GMT

Hi,
Does SAS plan to support median in 9.3?

Re: When will median function be supported in Proc SQL?

Cynthia_sas — Fri, 28 Aug 2009 11:26:39 GMT

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 — Thu, 03 Sep 2009 04:31:46 GMT

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

-Kevin