topic Re: PROC CHART? in SAS Procedures

PROC CHART?

GreggB — Fri, 04 Nov 2016 18:27:38 GMT

Here's a sample of the data I have:

letter band
A 4
B 3
A 7
C 2
C 7
D 1
F 8
A 10

I want 5 vertical stacked bar graphs. Each bar (A,B,C,D,F) will have 10 subcategories (1 - 10) that shows the frequency of each band in each letter category (A - F)

Re: PROC CHART?

ChrisHemedinger — Fri, 04 Nov 2016 18:46:43 GMT

I think you want to look at PROC SGPLOT and the VBAR statement. Use Group= and GroupDisplay=Stack. Examples here in this blog post.

Re: PROC CHART?

GreggB — Fri, 04 Nov 2016 19:35:58 GMT

Maybe i'm on the wrong track. I want a visual for the chart below. Letter has 5 values (A B C D F). I want to show that the relative size of each band, i.e. bands 5 and 6 represent the vast majority. (as is the case with the other letters)

letter	band	Frequency	Percent	Cumulative Frequency	Cumulative Percent
A	3	1	0.03	1	0.03
A	4	4	0.10	5	0.13
A	5	728	19.00	733	19.13
A	6	859	22.42	1592	41.56
A	7	15	0.39	1607	41.95
A	9	1	0.03	1608	41.97
B	2	1	0.03	1609	42.00
B	3	1	0.03	1610	42.03
B	4	5	0.13	1615	42.16
B	5	670	17.49	2285	59.65
B	6	684	17.85	2969	77.50
C	2	1	0.03	2970	77.53
C	4	8	0.21	2978	77.73
C	5	288	7.52	3266	85.25
C	6	287	7.49	3553	92.74
D	4	2	0.05	3555	92.80
D	5	98	2.56	3653	95.35
D	6	92	2.40	3745	97.76
F	4	2	0.05	3747	97.81
F	5	43	1.12	3790	98.93
F	6	41	1.07	3831	100.00
Frequency Missing = 809

Re: PROC CHART?

ChrisHemedinger — Fri, 04 Nov 2016 19:57:22 GMT

Here are some options for you.

ods graphics / height=1000 width=500;
proc sgplot data=work.comm;
 vbar letter / response=frequency stat=sum group=band 
   groupdisplay=stack grouporder=ascending barwidth=.5;
run;

/* cluster instead of stack */
ods graphics / height=800 width=500;
proc sgplot data=work.comm;
 vbar letter / response=frequency stat=sum group=band 
   groupdisplay=cluster grouporder=ascending barwidth=.7;
run;

/* Horizontal to go for a wide view */
ods graphics / width=1200 height=500;
proc sgplot data=work.comm;
 hbar letter / response=frequency stat=sum group=band 
   groupdisplay=stack grouporder=ascending barwidth=.5;
run;

VBAR example

VBAR with GROUPDISPLAY=CLUSTER

HBAR example, stacked

Re: PROC CHART?

GreggB — Fri, 04 Nov 2016 20:02:03 GMT

Excellent! Thanks.