Comparing Procedures That Produce Detail Reports
Overview
When you want to produce a detail
report, you can choose between the PRINT procedure and the SQL procedure:
Procedure
|
Description
|
---|---|
PROC PRINT
|
|
PROC SQL
|
|
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 O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.