Need help to understand the plot produced by proc sgplot

[Demographer]

Hi,

I produced a histogram with proc sgplot using this code: 

proc sgplot data=work.test;
  histogram age_num;
  density age_num;
run;

The plot produced is the followed:

As you can see, there are some irregularities for some ages. To validate, I tried to create the same chart using prec freq instead:

proc freq data=work.test;
table age_num /plots=freqplot;
run;

The chart is the following, which, as you can see, is very different, since there are no more irregularities.

So I wonder: how is this possible? Maybe I do not interpret correctly the output produced by the proc sgplot.

[PaigeMiller · Accepted solution]

In the SGPLOT output, there don't appear to be 20 bins in the range 41 and 60 (for example, it's probably true for all 20 unit increments). So you need to modify your SGPLOT code to make sure you have 20 bins for every 20 units on the x-axis.

[Tom]

Read this article

https://blogs.sas.com/content/iml/2014/08/25/bins-for-histograms.html