Creating a histogram in SAS

[Fara_I]

Hi,

I am attempting to create a histogram in SAS using the following data: 

data auto;
input IQscore @@;
datalines;
145 139 126 122 125 130 96 110 118 118
101 142 134 124 112 109 134 113 81 113
123 94 100 136 109 131 117 110 127 124
106 124 115 133 116 102 127 117 109 137
117 90 103 114 139 101 122 105 97 89
102 108 110 128 114 112 114 102 82 101
;

proc univariate data=auto noprint;
histogram IQscore/midpoints=(80 to 150 by 10);
run;

My issue is that when I run the program, it shows relative frequency of the data instead of the individual counts for the data (e.g. there are 16 counts of data in the interval between 105 and 115, but it showing 16/60(the total number of data)*100 = 26% instead when you examine the y-axis label).

I also need help changing the axis labels. Any tips are appreciated, thanks!

[Rick_SAS · Accepted solution]

/* display raw counts */
proc univariate data=auto noprint;
histogram IQscore/midpoints=(80 to 150 by 10) 
          vscale=count barlabel=count; 
run;

/* display relative percentages */
proc univariate data=auto noprint;
histogram IQscore/midpoints=(80 to 150 by 10) 
          vscale=percent barlabel=percent;
run;

You can display counts or percentages, or even mix and match! Use the VSCALE= and BARLABEL= options to specify your preferences.

[PGStats]

You will have more control with sgplot:

proc sgplot data=auto;
histogram IQScore / binstart=80 binwidth=10 
    datalabel=count datalabelattrs=(size=10) scale=count;
run; 

[Fara_I]

Thanks!