Sample 44115: Create a waterfall chart with the Graph Template Language (GTL)
This sample illustrates how to create a waterfall chart with the Graph Template Language (GTL). This sample code requires SAS® 9.3 or higher.
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.
This sample illustrates how to create a waterfall chart with the Graph Template Language (GTL). This sample code requires SAS® 9.3 or higher.
data totals;
input sex $ : Name $ Total dollar8.2;
datalines;
Male Martin 1229.00
Male Thomas -130.00
Male Bobby 3009.40
Male Gordon -400.95
Female Susan -730.43
Female Cindy -230.34
Female Sharon 543.90
Female Laura 2000.40
;
run;
proc sort data=totals;
by name;
run;
proc template;
define statgraph waterfall;
begingraph;
layout overlay;
waterfallchart category=name response=total / colorgroup=sex barlabel=true
name='waterfall' dataskin=gloss filltype=gradient;
discretelegend 'waterfall' / title='Sex';
endlayout;
endgraph;
end;
proc sgrender template=waterfall data=totals;
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.
This sample illustrates how to create a waterfall chart with the Graph Template Language (GTL).
| Type: | Sample |
| Topic: | Query and Reporting ==> Creating Reports ==> Graphical ==> Graph Template Language (GTL)
SAS Reference ==> Procedures ==> SGRENDER
|
| Date Modified: | 2011-10-17 14:21:59 |
| Date Created: | 2011-08-26 09:01:31 |
Operating System and Release Information
| SAS System | Base SAS | z/OS | 9.3 TS1M0 | |
| Z64 | 9.3 TS1M0 | |
| Microsoft® Windows® for x64 | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M0 | |
| Microsoft Windows Server 2008 | 9.3 TS1M0 | |
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M0 | |
| Microsoft Windows XP Professional | 9.3 TS1M0 | |
| Windows 7 Enterprise 32 bit | 9.3 TS1M0 | |
| Windows 7 Enterprise x64 | 9.3 TS1M0 | |
| Windows 7 Home Premium 32 bit | 9.3 TS1M0 | |
| Windows 7 Home Premium x64 | 9.3 TS1M0 | |
| Windows 7 Professional 32 bit | 9.3 TS1M0 | |
| Windows 7 Professional x64 | 9.3 TS1M0 | |
| Windows 7 Ultimate 32 bit | 9.3 TS1M0 | |
| Windows 7 Ultimate x64 | 9.3 TS1M0 | |
| Windows Vista | 9.3 TS1M0 | |
| Windows Vista for x64 | 9.3 TS1M0 | |
| 64-bit Enabled AIX | 9.3 TS1M0 | |
| 64-bit Enabled HP-UX | 9.3 TS1M0 | |
| 64-bit Enabled Solaris | 9.3 TS1M0 | |
| HP-UX IPF | 9.3 TS1M0 | |
| Linux | 9.3 TS1M0 | |
| Linux for x64 | 9.3 TS1M0 | |
| Solaris for x64 | 9.3 TS1M0 | |
