Greetings,
I have researched many posts regarding waterfall charts, and every example I have seen has the data vertically, meaning every observation will output to the same chart:
data DataDir.SJUCost;
input Name $
Number
Color $;
datalines;
2018 755575 Red
VFM 5628 Red
INT 135364 Red
OTH 3222 Red
DFM -138900 Green
;
run;
proc template;
define statgraph waterfall;
begingraph;
layout overlay;
waterfallchart category=name response=number /
colorgroup=color
barlabel=true
name='waterfall'
dataskin=sheen
filltype=solid
initialbarattrs=(color=gray4f)
display=(connect fill outline);
endlayout;
endgraph;
end;
proc sgrender template=waterfall data=DataDir.SJUCost;
title '2018 SJU Check Cost';
run;
But this is not my case, in my dataset, I need the waterfall chart to take in the variables horizontally, meaning I need to output a chart for every observation on the dataset (30 obs) . Here is the same data above:
data DataDir.SJUCost;
input Name $
Number
Color $;
datalines;
755575 5628 135364 3222 -138900
;
run;
How can i process the data horizontally?
Thanks.