Is there a way to create lollipo chart such as the one shown below using SAS ?. What procedures should I use. I have SAS 9.3.
Use SAS 9.3 PROC SGPANEL: You have more options using SAS 9.4 or later.
proc means data=sashelp.cars;
class origin type;
vars mpg_city;
output out=cars(where=(_type_ =3))
mean=MeanMpg;
run;
data cars;
set cars;
zero=0;
run;
proc print;run;
ods graphics / reset width=4in height=3in imagename='CarsPanel';
title 'Mileage by Origin and Type';
proc sgpanel data=cars noautolegend;
panelby origin / layout=rowlattice novarname uniscale=column;
highlow y=type low=zero high=meanmpg / group=type;
scatter y=type x=meanmpg / group=type markerattrs=(symbol=circlefilled);
colaxis offsetmin=0;
rowaxis display=(nolabel noticks) valueattrs=(size=6);
run;
It will help if you can provide some data to experiment with.
Hi,
Not a complete answer, but you should look into this site: http://blogs.sas.com/content/graphicallyspeaking/
They have a lot of grahphs with sample code and somewhere there is an index of all the graphs - might be worth a look.
Use SAS 9.3 PROC SGPANEL: You have more options using SAS 9.4 or later.
proc means data=sashelp.cars;
class origin type;
vars mpg_city;
output out=cars(where=(_type_ =3))
mean=MeanMpg;
run;
data cars;
set cars;
zero=0;
run;
proc print;run;
ods graphics / reset width=4in height=3in imagename='CarsPanel';
title 'Mileage by Origin and Type';
proc sgpanel data=cars noautolegend;
panelby origin / layout=rowlattice novarname uniscale=column;
highlow y=type low=zero high=meanmpg / group=type;
scatter y=type x=meanmpg / group=type markerattrs=(symbol=circlefilled);
colaxis offsetmin=0;
rowaxis display=(nolabel noticks) valueattrs=(size=6);
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.