Customized Reports with PROC REPORT in SAS

by finnstats

Customized Reports with PROC REPORT in SAS, PROC REPORT in SAS allows users to create formatted reports for datasets with a high degree of customization.

Customized Reports with PROC REPORT in SAS

The basic syntax for generating a report is straightforward:

/* Create report */
proc report data=my_data;
run;

This command produces a report that displays the rows of the dataset exactly as they are organized.

However, PROC REPORT offers various options to enhance and customize the report’s output.

Example of a Customized Report

You can customize reports by using additional statements.

For instance, here’s how to create a more tailored report for specific data:

/* Create customized report */
title 'Player Statistics for Dallas Mavericks';
proc report data=my_data;
   where team='Mavs';
   column conf team points;
   define conf / display 'Conference' center;
run;

Explanation of the Code Components

title: Sets a title for the report.
where: Filters the dataset to include only rows for the specified team, in this case, the ‘Mavs’.
column: Specifies which columns to include in the report and the order in which they should appear.
define: Customizes the display settings for a specific column. Here, it specifies that the column conf should be titled ‘Conference’ and that its values should be center-aligned.

Using PROC REPORT in Practice

To illustrate the application of PROC REPORT, let’s begin with the following dataset containing basketball player statistics:

/* Create dataset */
data my_data;
    input team $ points rebounds conf $;
    datalines;
Celtics 12 5 East
Celtics 14 7 East
Celtics 15 8 East
Celtics 18 13 East
Mavs 31 12 West
Mavs 32 6 West
Mavs 35 4 West
Mavs 36 10 West
Mavs 40 12 West
;
run;

/* View dataset */
proc print data=my_data;

Generating an Entire Dataset Report

To print the complete dataset without any modifications, you can use:

/* Create report that displays the entire dataset */
proc report data=my_data;
run;

This will produce a report featuring all entries and columns from the dataset.

Creating a Customized Report

Next, let’s create a customized version of the report for the ‘Mavs’ using PROC REPORT:

/* Create customized report */
title 'Player Statistics for Dallas Mavericks';
proc report data=my_data;
   where team='Mavs';
   column conf team points;
   define conf / display 'Conference' center;
run;

Differences in the Customized Report

The output of this customized report will differ significantly from the basic report:

Title: It includes a descriptive title.
Filtered Data: It only shows data for the ‘Mavs’ team.
Specific Columns: Only the conf, team, and points columns are displayed.
Column Customization: The conf column is labeled as ‘Conference’ and its values are center-aligned.

Conclusion

PROC REPORT is a powerful tool in SAS for generating reports that meet specific formatting and data presentation needs.

This example demonstrates a basic customization, but SAS provides numerous options for further tailoring reports.

For comprehensive details on additional customization capabilities, refer to the online documentation.

Explore and leverage these features to create reports that perfectly align with your requirements.

SAS Archives » FINNSTATS

Customized Reports with PROC REPORT in SAS