Comparing Procedures That Produce Detail Reports


When you want to produce a detail report, you can choose between the PRINT procedure and the SQL procedure:
  • can calculate column sums
  • can manipulate data and create a SAS data set in the same step that creates the report
  • can calculate column and row statistics
To perform a particular task, a single-purpose tool like PROC PRINT generally uses fewer computer resources than a multi-purpose tool like PROC SQL.
To illustrate the differences in resource usage between PROC PRINT and PROC SQL, consider some sample queries.

Example: Using PROC PRINT and PROC SQL to Create Detail Reports

Suppose you are ...

Get SAS Certification Prep Guide, 4th Edition 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.