topic Working out median using SQL in SAS Programming

Working out median using SQL

SAS_AMUH — Wed, 05 Jun 2019 11:09:46 GMT

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;

Re: Working out median using SQL

LinusH — Wed, 05 Jun 2019 11:55:22 GMT

Median is not supported by PROC SQL.

Use PROC SUMMARY/UNIVARIATE instead.

Re: Working out median using SQL

Ksharp — Wed, 05 Jun 2019 13:43:14 GMT

Linus,

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

Re: Working out median using SQL

LinusH — Tue, 11 Jun 2019 11:13:39 GMT

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