Output Delivery System: The Basics and Beyond

Importing Your ODS Output into a Spreadsheet

Because the Internet has become so pervasive, HTML is a widely accepted file format. This means that if you create ODS HTML output from your SAS program, you can probably read it into any other software you care to use. For example, you can take your HTML output and import it into a spreadsheet program such as Microsoft Excel. Since ODS HTML output is largely composed of tables, with rows and columns, a spreadsheet can easily interpret the results and format them properly.

The following code analyzes the CHGDBP and CHGSBP variables in the data set CLINICAL. It saves the same report three different ways that a spreadsheet program can easily open. ODS gives you three ways to generate formatted output ...