Desktop productivity for business analysts and programmers

PROC SGPANEL binwidth/binstart not applying

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

PROC SGPANEL binwidth/binstart not applying

Hi Everyone,

 

I am trying to create some basic histograms using proc sgpanel and I am having trouble with the binwidth and binstart options. On some of the graphs I create, one panel will not follow the width and starting point specified. For example, I have four panels on a graph, three of which start at the point identified (1.25) with binstart and have the appropriate width (2.5), but the last one has widths twice as big (5) and starts at a different point (0). 

 

Code:

proc sgpanel data = subjectlevel;
	panelby class;
	histogram score/ binwidth = 2.5 binstart = 1.25;
	colaxis values = (0 to 50 by 5);
run;	

graph.png

 

Is there any way to fix this problem?

 

Thanks!


Accepted Solutions
Solution
‎11-02-2017 05:11 PM
Occasional Contributor
Posts: 5

Re: PROC SGPANEL binwidth/binstart not applying

[ Edited ]

I fixed it by adding 0.0001 to my binwidth. so my code went from

proc sgpanel data = subjectlevel;
panelby class;
histogram score/ binwidth = 2.5 binstart = 1.25;
colaxis values = (0 to 50 by 5);
run;

to 

proc sgpanel data = subjectlevel;
 panelby class;
 histogram score/ binwidth = 2.5001 binstart = 1.25;
 colaxis values = (0 to 50 by 5);
run;

...

View solution in original post


All Replies
Super User
Posts: 13,920

Re: PROC SGPANEL binwidth/binstart not applying

You might look at the actual values of your score variable for the fourth value of the panelby variable.

 

I suspect some combination of values and intervals between values of the score variable are causing a problem.

Occasional Contributor
Posts: 5

Re: PROC SGPANEL binwidth/binstart not applying

For all of the groups, the scores are whole numbers, and the fourth group specifically has 10% of the data from 0-2 (so where the first bin should be).

Solution
‎11-02-2017 05:11 PM
Occasional Contributor
Posts: 5

Re: PROC SGPANEL binwidth/binstart not applying

[ Edited ]

I fixed it by adding 0.0001 to my binwidth. so my code went from

proc sgpanel data = subjectlevel;
panelby class;
histogram score/ binwidth = 2.5 binstart = 1.25;
colaxis values = (0 to 50 by 5);
run;

to 

proc sgpanel data = subjectlevel;
 panelby class;
 histogram score/ binwidth = 2.5001 binstart = 1.25;
 colaxis values = (0 to 50 by 5);
run;

...

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 209 views
  • 0 likes
  • 2 in conversation