I have data files that already have the variable of interest (mathpct34) summarized. I want a bar chart grouped by testgrade (3,4,5) that has a vertical bar to represent each value of mathpct34. I found an example that is similar to what I want. It uses the data from sashelp.prdsales. (see snippet below)
location | testgrade | mathpct34 |
local | 3 | 39.4 |
state | 3 | 42 |
national | 3 | 56 |
local | 4 | 39.8 |
state | 4 | 44.2 |
national | 4 | 56.3 |
local | 5 | 40.6 |
state | 5 | 38.1 |
national | 5 | 47.2 |
Hope this is what you are expecting
data want;
input location$ testgrade mathpct34;
cards;
local 3 39.4
state 3 42
national 3 56
local 4 39.8
state 4 44.2
national 4 56.3
local 5 40.6
state 5 38.1
national 5 47.2
;
proc sgplot data=want;
vbar testgrade / response=mathpct34 group=location groupdisplay=cluster;
xaxis display=(nolabel noline noticks);
run;
Hope this is what you are expecting
data want;
input location$ testgrade mathpct34;
cards;
local 3 39.4
state 3 42
national 3 56
local 4 39.8
state 4 44.2
national 4 56.3
local 5 40.6
state 5 38.1
national 5 47.2
;
proc sgplot data=want;
vbar testgrade / response=mathpct34 group=location groupdisplay=cluster;
xaxis display=(nolabel noline noticks);
run;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.