topic Re: Histograms in SAS Programming

Histograms

Shirin — Mon, 03 Jun 2013 14:30:27 GMT

Hello,

I am trying to make a simple histogram with counts on the vertical axis but I am getting very weird looking graphs...

I do have 76000 ID's in my data with each having a count:

ID count

1 89

2 126

3 569

. .

76000 176

I want each of the IDs to have a column and the column to be as tall as the count.

Thanks

Re: Histograms

Reeza — Mon, 03 Jun 2013 14:44:45 GMT

What code/proc are you using now that is giving you weird answers?

Re: Histograms

Shirin — Mon, 03 Jun 2013 14:46:55 GMT

I'm using a proc univariate

Re: Histograms

ballardw — Mon, 03 Jun 2013 15:05:00 GMT

Trying to create 76000 columns in a single chart is probably not ever going to work, especially with univariate.

Try either proc gplot or sgplot,maybe with a needle plot. Though you aren't going to have much luck associating any specific ID with it's count.

Re: Histograms

Reeza — Mon, 03 Jun 2013 15:13:27 GMT

Usually you can use weight for a variable when you have the counts already pre-processed, however the histogram statement does not support this in proc univariate.

I'll agree with BallardW suggestion of a Needle Plot.