Thanks for the fast reply, much appreciated. I understand your suggestion, but the SAS-VA report interface allows users to adjust which numbers go into the histogram. As you showed with SGPLOT, using the automatic algorithm results in a spiked histogram. Adjusting to: proc sgplot data=a.histogram_bin_problem;
histogram internal_reply_num / scale=count binwidth=0.02;
run Gives a nice smooth looking histogram. If the user then adust the input (albeit in SAS-VA): proc sgplot data=histogram_bin_problem;
histogram internal_reply_num / scale=count binwidth=0.02;
where internal_reply_num between 2 and 2.8;
run; The output is again get a "bad" looking histogram: So the input to the Histogram function (SGPLOT or SAS-VA) is dynamic, and I'm hoping for a better/different auto-binning algorithm. I have tried, as suggested by you, to use the number of bins that gives a smooth histogram, but then the input changes and I get a spiked histogram. I have attempted to use a parameter inside "Number of bins" to let the user adjust the look of the histogram, but parameters are not allowed as input. Hope thit makes sense
... View more
