Creating an Output Data Set from PROC REPORT

With other procedures, you use ODS OUTPUT to create an output data set. With the REPORT and TABULATE procedures, you can also create an output data set directly from the procedure.

A simple OUT= in the PROC REPORT statement is all you need to create an output data set. Theoutput data set has one observation for each row in the report. Each summary line is also written as an observation to the output data set as well.

ODS LISTING; proc report data=furniture nowd out=totaltables; column Type Material Price; define Type / group 'Table Type'; define Material / group 'Construction'; define Price / analysis mean 'Average Price' format=dollar8.; run; ODS HTML BODY='totalreport.html' STYLE=sasweb; proc print ...

Get Output Delivery System: The Basics and Beyond 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.