This SAS Note provides a sample on how to use the WATERFALL statement in PROC SGPLOT to show changes in transaction values. 

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

/* Create sample transaction data */
data transactions;
 length id $10;
 format Amount dollar.;
 input ID $ Amount type $;
 datalines;
Income-1    2000 Credit
Income-2    1000 Credit
Interest    200  Credit
Rent       -800  Debit
Car        -400  Debit
Grocery    -500  Debit
Utilities  -400  Debit
;
run;

ods graphics / reset attrpriority=none width=6in height=4in imagename="WaterfallChart";

title 'Cash Flow';
proc sgplot data=transactions;
  /* Define the colors for the Credit and Debit bars */
  styleattrs datacolors=(cx8FB38F cxF2AE49);
  waterfall category=id response=amount  / colorgroup=type dataskin=sheen 
     datalabel finalbarattrs=(color= gray99);                                                  
  keylegend  / title='Transaction type' location=inside position=topright across=1;
  xaxis display=(nolabel);
  yaxis grid display=(nolabel) offsetmin=0;
run;

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

Operating System and Release Information