Introduction

If you work with data, chances are good that you also need to create reports based on your data. For example, suppose that you run a specialty foods shop and need to prepare some reports for regular board meetings. You need to create reports such as the following:

  • a list report that groups the data by supplier and displays totals for each supplier and for all products

  • a frequency report that shows the number of orders for each product category and supplier, and the percentage of total orders that each product category and supplier represents

  • a summary table that shows the number of orders and the number of products that have been sold, the total and average profit for orders, and the percentage of total sales

  • a bar chart that shows total profit by product category.

SAS Enterprise Guide reports


You can use SAS Enterprise Guide to easily create detail and summary reports from your data. You can also customize the reports in many ways by selecting various report formats, applying styles to HTML results, and creating custom formats. In this lesson, you learn various ways to present the information that the board has requested, and you create and customize all the reports that are shown above.




SAS Enterprise Guide reports


You can use SAS Enterprise Guide to easily create detail and summary reports from your data. You can also customize the reports in many ways by selecting various report formats, applying styles to HTML results, and creating custom formats. In this lesson, you learn various ways to present the information that the board has requested, and you create and customize all the reports that are shown above.


This lesson contains pages and takes approximately 2 hours to complete.


In this lesson, you learn to do the following:

  • create detail reports
  • format variables in a report
  • create frequency reports
  • create summary reports
  • create graphs
  • specify result formats
  • create custom styles
  • use styles to customize your HTML results
  • create and apply custom formats
  • edit task code to add traffic lighting to a summary report.

Before taking this lesson, you should complete the Getting Started tutorial for SAS Enterprise Guide or SAS Learning Edition. (To take the tutorial, start SAS Enterprise Guide or SAS Learning Edition and select HelparrowGetting Started Tutorial.)