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;
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.
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.