topic Re: Changing the size of the bubbles in SGPLOT in Graphics Programming

Changing the size of the bubbles in SGPLOT

Recep — Thu, 06 Apr 2017 19:54:51 GMT

Hello there,

Can anyone help with changing the size of the bubbles in SGPLOT? The bubbles in my graph below are not proportional to the size of each cell. I would like to make them smaller than how they look in the graph. In the preceeding data step I tried to change the value of the "size" variable but it did not seem to help.

Thanks a lot in advance!

Recep

data _009;
merge _007 _008 rprt1516.bc_population_estimates_by_age;
by age_group_1;
dad_per_100000=100000*dad_count/population;
bctr_per_100000=100000*bctr_count/population;

size=0.1;

run;

proc sgplot data=_009;
bubble x=age_group_1 y=dad_count size=size / LEGENDLABEL= "All hospitalizations"
FILLATTRS=(color=red transparency=0.6);
bubble x=age_group_1 y=bctr_count size=size / LEGENDLABEL= "BCTR hospitalizations (ISS>=9 or died)"
FILLATTRS=(color=blue transparency=0.6);

xaxis display=all label='Age group' fitpolicy=rotate;
yaxis label='Total cases' offsetmin=.17;
run;

Re: Changing the size of the bubbles in SGPLOT

Reeza — Thu, 06 Apr 2017 20:02:07 GMT

Can you post an example that references a SASHELP dataset so we can replicate the issue.

It should be the SIZE that controls the size.

Was there any messages in the log?

Re: Changing the size of the bubbles in SGPLOT

Jay54 — Thu, 06 Apr 2017 20:08:25 GMT

For Bubble plot, size=column uses the BRADIUSMIN and BRADIUSMAX to map the values from the column. If the column has only one value, all bubbles will be of the size specified by BRADIUSMIN. So, in this case you can set the BRADIUSMIN and BRADIUSMAX values to what you want. Please see product documentation.

Re: Changing the size of the bubbles in SGPLOT

DanH_sas — Thu, 06 Apr 2017 20:12:00 GMT

Based on your data step, it appears that you are trying to create bubbles of a constant size. The intent of a BUBBLE plot is to have varying sized bubbles to reflect the changes in a third variable. I think what you might want is a SCATTER plot with CIRCLEFILLED markers. Something like this:

proc sgplot data=sashelp.class;
scatter x=weight y=height / markerattrs=(symbol=circlefilled size=21px) 
           filledoutlinedmarkers group=sex;
run;

Hope this helps!

Dan

Re: Changing the size of the bubbles in SGPLOT

Recep — Thu, 06 Apr 2017 20:18:37 GMT

Thanks a lot Sanjay! It resolved my problem easily...

Re: Changing the size of the bubbles in SGPLOT

Recep — Thu, 06 Apr 2017 20:20:14 GMT

Thanks a lot for your response Dan! Sanjay's solution resolved my problem. Though I'll try to use the scatter option instead of bubbles as I believe there are a bit more flexibility with the scatter.

Cheers,

Recep

Re: Changing the size of the bubbles in SGPLOT

Recep — Thu, 06 Apr 2017 20:22:33 GMT

Hi Reeza,

Here is the dataset:

age_group_1	dad_count	bctr_count	population	dad_per_100000	bctr_per_100000	size
0-15	1580	241	691527	228.48	34.85	0.1
16-19	575	156	272558	210.96	57.236	0.1
20-24	938	280	326885	286.95	85.657	0.1
25-29	1004	293	317345	316.37	92.329	0.1
30-34	856	241	328085	260.91	73.457	0.1
35-39	800	224	312835	255.73	71.603	0.1
40-44	920	229	304587	302.05	75.184	0.1
45-49	1017	292	327972	310.09	89.032	0.1
50-54	1385	377	351517	394.01	107.249	0.1
55-59	1577	407	351325	448.87	115.847	0.1
60-64	1650	423	316552	521.24	133.627	0.1
65-69	1751	390	281853	621.25	138.37	0.1
70-74	1836	316	203061	904.16	155.618	0.1
75-79	2109	297	146672	1437.9	202.493	0.1
80-84	2802	365	106992	2618.89	341.147	0.1
85-89	3088	375	69643	4434.04	538.46	0.1
90+	3146	298	42203	7454.45	706.111	0.1

I haven't got any message in the log. Sanjay's solution was quite easy to apply.