topic Proc Sgplot Vbar with two columns as bars (stacked) in SAS Programming

Proc Sgplot Vbar with two columns as bars (stacked)

CIG21 — Thu, 15 Oct 2020 23:03:53 GMT

Hello everyone!

I'm having a dataset in SAS which looks similar to the below picture one and I am trying to create the same graph in SAS with proc sgplot and vbar, however, I struggle to be able to choose the two columns for the bars. With the response and group command I can only choose one of each...

I also tried it with two vbars in one proc sgplot and the response being for one active cases and for the other passive cases, however, that did not work properly.

Is there any way how I can achieve creating the below graph? Or do I have to change my dataset first, if yes, how? I'd prefer to stay with proc sgplot, if possible. Any help is greatly appreciated 🙂

Re: Proc Sgplot Vbar with two columns as bars (stacked)

CurtisMackWSIPP — Thu, 15 Oct 2020 23:15:57 GMT

VBAR wants the data structured differently. The stack value needs to be a variable. Something like this.

data have;
  infile cards dsd;
  input weekday $ var1 var2;
  format datetime1 datetime2 datetime20.;
cards; 
Monday,23,12
Tuesday,21,4
Wednesday,4,5
Thursday,5,29
Friday,8,9
;
run;

data want;
  set have;
  actual = var1; cat="cat1"; output;
  actual = var2; cat="cat2"; output;
run;

proc sgplot data=want;
  title 'Actual Sales by Day';
  vbar weekday / response=actual group=cat stat=sum;
  xaxis display=(nolabel);
  yaxis grid  label='Sales';
  run;

Re: Proc Sgplot Vbar with two columns as bars (stacked)

CIG21 — Thu, 15 Oct 2020 23:24:22 GMT

Brilliant, exactly what I needed. Thank you!