Help using Base SAS procedures

When will median function be supported in Proc SQL?

Reply
Contributor
Posts: 43

When will median function be supported in Proc SQL?

Hi,
Does SAS plan to support median in 9.3?
SAS Super FREQ
Posts: 8,743

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

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
Contributor
Posts: 43

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

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

-Kevin
Ask a Question
Discussion stats
  • 2 replies
  • 187 views
  • 0 likes
  • 2 in conversation