Working out median using SQL

[SAS_AMUH]

I am quite new to the sql. 

The following code worked fine. 

However, I would like to add a programming code that will enable me to get MEDIAN.

Could anyone please help?

Thank you in advance. 

proc sql;
select type,
count(IPtotal) as _N ,
nmiss(IPtotal) as _MISS ,
avg(IPtotal) as _AVG ,
min(IPtotal) as _MIN ,
max(IPtotal) as _MAX ,
range(IPtotal) as _RANGE ,
std(IPtotal) as _STD ,
var(IPtotal) as _VAR
from didi
group by type;
quit;

[LinusH]

Median is not supported by PROC SQL.

Use PROC SUMMARY/UNIVARIATE instead.

[Ksharp · Accepted solution]

Linus,

Median() function is  supported by PROC SQL if you have SAS9.4

[LinusH]

I missed that @Ksharp , thanks for pointing it out!