Output Delivery System: The Basics and Beyond

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 ...