Creating a Custom Table Template with a DATA Step
In this first example, we design the custom table template HR_TABLE based on two variables from the HR data set and on two variables calculated in the DATA step that creates a report. The template is stored in the TABLES folder in the WORK.NEWTEMP item store. Here's the template:
ODS PATH WORK.NEWTEMP(UPDATE) SASHELP.TMPLMST(READ); proc template; define table tables.hr_table; column Department AnnualSalary BonusAmt NewSal; define Department; header='Dept'; end; define AnnualSalary; header='Annual'; format=dollar14.2; end; define BonusAmt; header = '#Bonus#@5%'; format=7.2; end; define NewSal; header = 'Adjusted'; format=dollar14.2; end; end; run;
This simple template specifies attributes for ...
Get Output Delivery System: The Basics and Beyond now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.