2 datasets/series in one graph

AnetteD — Wed, 09 Mar 2016 09:00:59 GMT

Hi All

I am trying to make the attached graph in SAS - that is I want to make a proc gchart vbar on one dataset and a proc sqplot on another dataset and then combine the two graphs using proc greplay, but it just doesnt look pretty - does anybody have any other ideas ?

Re: 2 datasets/series in one graph

BrunoMueller — Wed, 09 Mar 2016 09:56:42 GMT

You combine the data that needs to be plotted into one data set using different varibale names, see below for an example

You then can use the appropriate plot statements of Proc SGPLOT that are compatible with each other, for your example they are VBARPARM and SCATTER

Here is a code sample that creates two tables with the data to be plotted, they are combined and then used with Proc SGPLOT

proc sql;
  create table carsAggr1 as
  select
    origin
    , type
    , mean(horsePower) as avg_horsePower
  from
    sashelp.cars

  group by
    origin
    , type
  ;
quit;

proc sql;
  create table carsAggr2 as
  select
    origin as origin2    
    , count(*) / (select count(*) from sashelp.cars) as share_pct format=percent9.1
  from
    sashelp.cars

  group by
    origin
  ;
quit;

data carsAggr3;
  set carsAggr1 carsAggr2;
  *
  * fill it, so we do not get an additional legend entry
  *;
  if type = " " then do;
    type = "SUV";
  end;
run;

proc sgplot data=carsAggr3;
  vbarparm category=Origin response=avg_horsePower / group=Type name="bar";
  scatter x=origin2 y=share_pct / 
    y2axis 
    markerattrs=(symbol= squarefilled)
    name="scatter"
    datalabel
    datalabelpos=top
  ;
  keylegend "bar" "scatter" / 
    location=outside
    position=right
    noborder
  ;
  y2axis values=(0 to 1.2 by 0.2);
run;

Bruno

Re: 2 datasets/series in one graph

AnetteD — Wed, 09 Mar 2016 14:00:38 GMT

Hi Bruno

Thank you very much for the help - it worked 🙂

Anette

topic Re: 2 datasets/series in one graph in Graphics Programming

2 datasets/series in one graph

Re: 2 datasets/series in one graph

Re: 2 datasets/series in one graph