Collaboration Investigate

Evolution of the Investigator Satisfaction Ranking Report: The Advantage of Using the "PROC REPORT Procedure/ODS Excel" Versus a "CROSSTAB Output" or "CROSSTAB/ODS Excel"

Download now Free registration required

Executive Summary

This paper describes the evolution of the SAS programming of a report used in employee evaluations by a government agency. The data is taken from a survey seeking customers' opinion of the service they received from the agency. The author entered the data into a SAS dataset and developed a ranking for each employee. The agency requires the final report to be in Excel. When they began processing the report, the programming was written in SAS Version 6. The report was derived from a CROSSTAB output .LST file and typed into an Excel table. With SAS Version 8, the authors' were able to output the CROSSTAB table into an Excel file using ODS. Although the results were in Excel, they still required much editing.

  • Format: PDF
  • Size: 565.2 KB