🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Quartz | Level 8

## How to create a histogram with median as a middle point

Is it possible to create a histgram with only 2 uneven bins: ">= median"  and  "< median" ?  Using either proc univariate, or sgplot.  How to set the middle or endpoint?  Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: How to create a histogram with median as a middle point

What do you mean by endpoints? If I understand you correctly, you can do something like this

``````proc sql;
create table temp as
select *,
median(height),
(case
when height lt median(height) then "< median"
when height ge median(height) then ">= median"
end) as overunder
from sashelp.class;
quit;

proc sgplot data=temp;
vbar overunder;
run;``````
2 REPLIES 2
Super User

## Re: How to create a histogram with median as a middle point

What do you mean by endpoints? If I understand you correctly, you can do something like this

``````proc sql;
create table temp as
select *,
median(height),
(case
when height lt median(height) then "< median"
when height ge median(height) then ">= median"
end) as overunder
from sashelp.class;
quit;

proc sgplot data=temp;
vbar overunder;
run;``````
Super User

## Re: How to create a histogram with median as a middle point

@HappySASUE wrote:

Is it possible to create a histgram with only 2 uneven bins: ">= median"  and  "< median" ?  Using either proc univariate, or sgplot.  How to set the middle or endpoint?  Thanks

Sure, that's just a bar chart though, I wouldn't call it a histogram. And in theory, it should be a straight line because that's the definition of the median.

Discussion stats
• 2 replies
• 551 views
• 3 likes
• 3 in conversation