Clustered Bar Chart not Not Displaying as Expected

[NeilH]

I'm trying to create a clustered bar chart where the two bars within each cluster are side by side without space in between. My code is separating the clusters by bar color, but doesn't seem to be doing it spatially. I've tried adjusting both the barwidth and clusterwidth options unsuccessfully. They both seem to be affecting just the bar widths.  I appreciate assistance on getting the display right. My data, code, and results are below. Thanks.

InstAll	pr1	d1	survey
f_pr_score1	25	25.0	Faculty
s_pr_score1	55.66666667	55.7	Student
f_pr_mean1	59.86574737	59.9	Faculty
s_pr_mean1	60.67674272	60.7	Student

data temp4;
input install $11. pr1 d1 survey $;
cards;
f_pr_score1 25 25.0 Faculty
s_pr_score1 55.66666667 55.7 Student
f_pr_mean1 59.86574737 59.9 Faculty
s_pr_mean1 60.67674272 60.7 Student
;
run;

proc sgplot data=temp4;
title 'A student body that reflects the diversity of society at large';
vbar install / response=pr1 datalabel=d1 barwidth=.25 group=survey groupdisplay=cluster;
yaxis label='Rating';
xaxis values=('f_pr_score1' 'f_pr_mean1' 's_pr_score1' 's_pr_mean1') 
	  valuesdisplay=('Faculty Rating' 'Faculty National Mean' 'Student Rating' 'Student National Mean')
 	  display=(nolabel);
run;

[ballardw]

Please post code as text instead of as pictures by copy and pasting into either a text or code box opened on the forum with the </> or "running man" icons that appear above the message window. If we want to make code changes as possible solutions to your question it much easier for us to copy / paste/ edit than to retype everything from scratch.

Similarly data should not be a picture but text and best as working data step to recreate your data set.

To get graph like I think you intend the variable Install should have two values, likely Score and Mean. Then both of the scores would appear adjacent and both of the means with the Survey value providing the color.

I can't provide an actually working example because pictures and I'm way too lazy to attempt to recreate everything from scratch.

[NeilH]

Thanks for the tip. I edited my post to paste in the code.

[Rick_SAS · Accepted solution]

I think if you restructure the form of your data, you'll be able to get what you want. Is this the desired output?

data temp4;
input survey $ Source $ pr1 d1 ;
datalines;
Faculty Local    25   25
Student Local    55.6 55.7
Faculty National 59.8 59.9
Student National 60.6 60.7
run;

title 'A student body that reflects the diversity of society at large';
proc sgplot data=temp4;
   vbar Survey / response=pr1 datalabel=d1 group=source groupdisplay=cluster;
   yaxis label='Rating';
   xaxis display=(nolabel);
run;

 

[NeilH]

Thank you, Rick. That worked!