How do I make this graph? I am getting too many outputs:

cvilme1998 — Thu, 24 Dec 2020 21:17:24 GMT

I was trying to categorize values in sashelp.bweight like below so I can make this graph:

Infant Weight Category Definition:

Value range	Category Label
Less than 3000 g	low
Between 3000 g and 3500 g (inclusively)	below average
Greater than 3500 g and less than or equal to 4000 g	above average
Over 4000 g	high

Attempted this code, but I got too many outputs and it was not as clean as the graph I was aiming for above. Is there a way to improve this code or an easier code to try?

proc format; value weight
low-<3000= "Low"
3000<=x<=3500= "Below Average"
3500>=90000= "Above Average"
4000>high "High"; Run;

proc freq data=sashelp.bweight; table weight*cigsperday;
format weight weight. cigsperday cigsperday.;
ods output CrossTabFreqs=work.sasbweight; run;
ods listing;

proc sgplot data=sashelp.bweight;
ods graphics on/discretemax=2500;
hbar weight. / response=cigsperday. group=momedlevel groupdisplay=cluster;
xaxis label="Cigarettes Per Day" grid gridattrs=(color=gray66)
values=(0 to 4 by 1);
yaxis label="Infant Birth Weight";
keylegend / position = bottom;
run;

Re: How do I make this graph? I am getting too many outputs:

PGStats — Thu, 24 Dec 2020 22:13:15 GMT

With proper syntax:

proc format; value weight
low-3000 = "Low"
3000-3500 = "Below Average"
3500-4000 = "Above Average"
4000-high = "High"; 
Run;

proc sgplot data=sashelp.bweight;
format weight weight.;
hbar weight / response=cigsperday group=momedlevel groupdisplay=cluster 
    stat=mean limitstat=stderr limits=upper;
xaxis label="Cigarettes Per Day" grid gridattrs=(color=gray66)
    values=(0 to 4 by 1) offsetmax=0.15;
yaxis label="Infant Birth Weight";
keylegend / position = bottom;
run;

topic Re: How do I make this graph? I am getting too many outputs: in New SAS User

How do I make this graph? I am getting too many outputs:

Re: How do I make this graph? I am getting too many outputs: