BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
GreggB
Pyrite | Level 9

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

 

GreggB_0-1632490388285.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Jagadishkatam
Amethyst | Level 16

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;

Jagadishkatam_0-1632491925036.png

 

Thanks,
Jag

View solution in original post

1 REPLY 1
Jagadishkatam
Amethyst | Level 16

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;

Jagadishkatam_0-1632491925036.png

 

Thanks,
Jag

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 605 views
  • 0 likes
  • 2 in conversation