Getting Started with the SAS® 9.4 Output Delivery …

1 Getting Started with the SAS Output Delivery SystemSAS DocumentationThe correct bibliographic citation for this manual is as follows: SAS Institute Inc. 2013. Getting Started with the SAS Output Delivery System. Cary, NC: SAS Institute Started with the SAS Output Delivery SystemCopyright 2013, SAS Institute Inc., Cary, NC, USAAll Rights Reserved. Produced in the United States of a hard copy book: No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, or otherwise, without the prior written permission of the publisher, SAS Institute a web download or e-book.

2 Your use of this publication shall be governed by the terms established by the vendor at the time you acquire this scanning, uploading, and distribution of this book via the Internet or any other means without the permission of the publisher is illegal and punishable by law. Please purchase only authorized electronic editions and do not participate in or encourage electronic piracy of copyrighted materials. Your support of others' rights is Government License Rights; Restricted Rights: The Software and its documentation is commercial computer software developed at private expense and is provided with RESTRICTED RIGHTS to the United States Government.

3 Use, duplication, or disclosure of the Software by the United States Government is subject to the license terms of this Agreement pursuant to, as applicable, FAR , DFAR (a), DFAR (a), and DFAR , and, to the extent required under federal law, the minimum restricted rights as set out in FAR (DEC 2007). If FAR is applicable, this provision serves as notice under clause (c) thereof and no other notice is required to be affixed to the Software or documentation. The Government s rights in Software and documentation shall be only those set forth in this Institute Inc.

4 , SAS Campus Drive, Cary, NC 27513-2414 November 2016 SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. indicates USA brand and product names are trademarks of their respective :odsgsContentsAbout This Book .. vAccessibility .. xiChapter 1 Introduction .. 1 What Is the Output Delivery System? .. 1 Benefits of Using ODS .. 2 How Does ODS Work? .. 3 Basic Usage .. 5 ODS-Specific Windows .. 13 Words to Know .. 16 Chapter 2 Learning by Example: Creating Custom Reports with ODS.

5 19 About the Scenario in This Book .. 19 Creating the Default Output .. 19 Chapter 3 Creating an ODS Document .. 23 About the Task That You Will Perform .. 23 Creating an ODS Document .. 23 For More Information .. 26 Chapter 4 Selecting the Contents of Your Report .. 27 About the Tasks That You Will Perform .. 27 Identify the Output Objects .. 27 Select the Output Objects .. 30 For More Information .. 40 Chapter 5 Integrating Output with Popular Business Applications and SAS .. 41 About the Tasks That You Will Perform .. 41 Creating RTF Output .

6 42 Creating an E-Book .. 44 Creating PowerPoint Output .. 45 Creating PDF Output .. 47 Creating Enhanced HTML Output .. 48 Creating Excel Output .. 50 Combined Program .. 50 For More Information .. 54 Chapter 6 Customizing the Presentation of a Report .. 55 About the Tasks That You Will Perform .. 55 Customized RTF Output .. 57 Customized E-Book .. 58 Customized PowerPoint Output .. 60 Customized PROC TABULATE Output .. 62 Customized PDF Output .. 64 Customized HTML Output .. 66 Customized Excel Output .. 67 Combined Program .. 69 For More Information.

7 73 Chapter 7 Next Steps: A Quick Look at Advanced Features .. 75 Working with the TEMPLATE Procedure .. 75 Working with ODS Graphics .. 81 Advanced Features of the DOCUMENT Procedure .. 85 ODS and the DATA Step .. 89 Working with Cascading Style Sheets (CSS) .. 91 Working with the ODSTEXT Procedure .. 93 Working with the ODSLIST Procedure .. 94 Working with the ODSTABLE Procedure .. 96 Working with the Report Writing Interface .. 97 Working with ODS LAYOUT .. 100 Where to Go from Here .. 103 Recommended Reading .. 105 Index .. 107ivContentsAbout This BookAudienceThis book is intended for new or novice users of the SAS Output Delivery System.

8 The documentation assumes familiarity with Base SAS programming and the SAS windowing environment. Although this familiarity is assumed, users who are not familiar will still be able to complete the tasks that are described in this Conventions for the SAS LanguageOverview of Syntax Conventions for the SAS LanguageSAS uses standard conventions in the documentation of syntax for SAS language elements. These conventions enable you to easily identify the components of SAS syntax. The conventions can be divided into these parts: syntax components style conventions special characters references to SAS libraries and external filesSyntax ComponentsThe components of the syntax for most language elements include a keyword and arguments.

9 For some language elements, only a keyword is necessary. For other language elements, the keyword is followed by an equal sign (=). The syntax for arguments has multiple forms in order to demonstrate the syntax of multiple arguments, with and without the name of the SAS language element that you use when you write your program. Keyword is a literal that is usually the first word in the syntax. In a CALL routine, the first two words are these examples of SAS syntax, the keywords are bold:CHAR (string, position)CALL RANBIN (seed, n, p, x);vALTER (alter-password)BEST <data-set-name>In this example, the first two words of the CALL routine are the keywords:CALL RANBIN(seed, n, p, x)The syntax of some SAS statements consists of a single keyword without arguments:DO.

10 SAS code ..END;Some system options require that one of two keyword values be specified:DUPLEX | NODUPLEXSome procedure statements have multiple keywords throughout the statement syntax:CREATE <UNIQUE> INDEX index-name ON table-name (column-1 <, column-2, ..>)argumentspecifies a numeric or character constant, variable, or expression. Arguments follow the keyword or an equal sign after the keyword. The arguments are used by SAS to process the language element. Arguments can be required or optional. In the syntax, optional arguments are enclosed in angle brackets ( < > ).