Data visualization with SAS programming

Lollipop Chart in SAS

Accepted Solution Solved
Reply
Contributor
Posts: 39
Accepted Solution

Lollipop Chart in SAS

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.

3-19-2015 5-59-19 PM.jpg


Accepted Solutions
Solution
‎03-19-2015 08:18 PM
SAS Super FREQ
Posts: 1,044

Re: Lollipop Chart in SAS

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;

CarsPanel.png

View solution in original post


All Replies
Grand Advisor
Posts: 9,740

Re: Lollipop Chart in SAS

It will help if you can provide some data to experiment with.

Super Contributor
Posts: 358

Re: Lollipop Chart in SAS

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.

Solution
‎03-19-2015 08:18 PM
SAS Super FREQ
Posts: 1,044

Re: Lollipop Chart in SAS

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;

CarsPanel.png

Post a Question
Discussion Stats
  • 3 replies
  • 413 views
  • 0 likes
  • 4 in conversation