topic Re: sgplot, histogrma on log(10) scale in Graphics Programming

sgplot, histogrma on log(10) scale

Tz — Tue, 05 Aug 2014 12:57:29 GMT

Hi all.

I am trying to use Sgplot to create a histogram on the log scale.

My variable is positive.

Syntax and sample file attached.

I get an error message that the scale includes zeoro or negative values.

What am I doing wrong?

Thanks

Re: sgplot, histogrma on log(10) scale

RW9 — Tue, 05 Aug 2014 13:06:37 GMT

Cant see your code, the queue seems to be blocked. Anyways, you are sure the data you are using has no number of 0 or less? If you have a zero, then maybe consider adding 0.0001 to it so it looks on the output like 0, however behind the scenes its really just over.

Re: sgplot, histogrma on log(10) scale

Tz — Wed, 06 Aug 2014 04:07:36 GMT

The variable is positive - no zeros.

This is the code:

prog sgplot;

histogram dmp / scale=count;

xaxis type=log base=10 logstyle=linear;

run;

thanks

Re: sgplot, histogrma on log(10) scale

RW9 — Wed, 06 Aug 2014 08:01:55 GMT

Couldn't see anything directly wrong with that, maybe try changing base to be 2 or E though I don't think it would have any effect, I would still say its in the data though I can't see as the Queue has broken here so files are not available.

Re: sgplot, histogrma on log(10) scale

ballardw — Wed, 06 Aug 2014 15:04:02 GMT

Please show output of the variable from Proc Means or similar showing at least the min value.

Re: sgplot, histogrma on log(10) scale

Jay54 — Wed, 06 Aug 2014 15:13:05 GMT

Since your data and program zip files are still under scan, it is hard to figure out what may be going on. Can you provide a simple case to illustrate the problem using one of the SASHELP data sets like Cars or Heart, along with the full program?

Re: sgplot, histogrma on log(10) scale

Community_Help — Wed, 06 Aug 2014 15:33:30 GMT

I'm checking on the virus scan with our IT department - thank you for your patience

Re: sgplot, histogrma on log(10) scale

jakarman — Sat, 23 Aug 2014 14:52:43 GMT

The problem is there are automatic created intervals with a count of zero. A value of zero cannot be positioned logaritmic.
There must be an other way of scaling 0-1-10-100-1000 (that is 10log like based) a try for that with the binning. Do not see how to influence the binning on that.

Re: sgplot, histogrma on log(10) scale

Jay54 — Mon, 25 Aug 2014 03:12:30 GMT

See article: Histograms on Log Axis - Graphically Speaking