Sample 51927: New options in PROC PRINT to add summary row labels in SAS® 9.4
 |  |  |  |  |  |
In SAS 9.4, the new PRINT procedure options SUMLABEL= and GRANDTOTAL_LABEL= enable you to specify summary row labels for BY groups and for the grand total row. Text that is specified with the SUMLABEL= option (SUMLABEL='Subtotal', for example) is displayed in the BY-group summary row. For ODS results, you can use the #BYVAL and #BYVAR options in the labels.
The sample code on the Full Code tab illustrates the syntax.
The previous SUMLABEL option is still available and allows for usage of a variable's label to display instead of the variable name.
Consult the online documentation for the PRINT procedure for additional information.
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.
In SAS 9.4, the new PRINT procedure options SUMLABEL= and GRANDTOTAL_LABEL= enable you to specify summary row labels for BY groups and for the grand total row. Text that is specified with the SUMLABEL= option (SUMLABEL='Subtotal', for example) is displayed in the BY-group summary row. For ODS results, you can use the #BYVAL and #BYVAR options in the labels.
The sample code below illustrates the syntax.
proc sort data=sashelp.class out=class;
by sex;
run;
proc format;
value $genderf
'F'='Female'
'M'='Male';
run;
proc print data=class noobs
sumlabel='#byval(sex) Total' grandtotal_label='Grand Total';
by sex;
var name age height weight;
sum height weight;
format sex $genderf.;
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.
| Type: | Sample |
| Date Modified: | 2014-01-14 15:53:57 |
| Date Created: | 2013-12-29 13:23:28 |
Operating System and Release Information
| Product Family | Product | Host | SAS Release | |
| Starting | Ending | |||
| SAS System | Base SAS | Solaris for x64 | 9.4 TS1M0 | |
| Linux for x64 | 9.4 TS1M0 | |||
| HP-UX IPF | 9.4 TS1M0 | |||
| 64-bit Enabled Solaris | 9.4 TS1M0 | |||
| 64-bit Enabled HP-UX | 9.4 TS1M0 | |||
| 64-bit Enabled AIX | 9.4 TS1M0 | |||
| Windows 7 Professional x64 | 9.4 TS1M0 | |||
| Windows 7 Enterprise x64 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Std | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Pro | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M0 | |||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M0 | |||
| Microsoft® Windows® for x64 | 9.4 TS1M0 | |||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.4 TS1M0 | |||
| z/OS | 9.4 TS1M0 | |||