What's New This third edition of The Little SAs Book: A Primer includes features added since sas 7--and there are a lot of them. When we wrote the second edition, the basic structure of the Output Delivery System(ODS) was in place, but few of its features were. Since then, flesh has been added to the bones and Ods now has a multitude of destinations and options. So, we have added a new chapter devoted entirely to Ods Exporting data is another greatly expanded topic. In previous editions we had a few scattered sections describing how to get data out of SAs for use in other applications, but the number of ways and number of types of files you can create has grown to the point that we felt a need to give a chapter all their own Other new topics are sprinkled throughout the book. For the first time we have included PROC REPORT. In addition, we ve expanded our coverage of the SAS Explorer window, the IMPORT and EXPORT Wizards, Dynamic Data Exchange(DDE), direct-referencing of AS data sets, and PROC TABULATE Weve added more system options, and a section on advanced input with the @character'column pointer and the colon modifier Most of the features in this edition are available with SAS 8.2 a few are new with sas 9 or SAS 9. 1. We have tried to point out whenever a feature is new. So unless otherwise noted, you can assume that everything in this book is available in SAS 8.2 Here, listed by section, are the new topics The Output Delivery System Section Feature Basic concepts for understanding ODS ODS TRACE and ODS SELECT statements allow you to choose which parts of ODS OUTPUT statement allows you to save results from SAS procedures as SAs 5.4-5.6 HTML, RTE, and PRINTER output can be created using ODS statements Titles and footnotes can be customized using the COlor=, BCOLOR=, HEIGHT- JUSTIFY=, FONT=, BOLD, and ITALIC options. 5.8-5.10 STYLE= option in PROC PRINT, PROC REPORT, and PROC TABULATE allows yo to control almost any aspect of the appearance of your output 5.11 Traffic-lighting draws attention to important values in reports by determining the 5.12 Table of selected style attributes shows some of the most popular features that you can control
What’s New This third edition of The Little SAS Book: A Primer includes features added since SAS 7—and there are a lot of them. When we wrote the second edition, the basic structure of the Output Delivery System (ODS) was in place, but few of its features were. Since then, flesh has been added to the bones and ODS now has a multitude of destinations and options. So, we have added a new chapter devoted entirely to ODS. Exporting data is another greatly expanded topic. In previous editions we had a few scattered sections describing how to get data out of SAS for use in other applications, but the number of ways and number of types of files you can create has grown to the point that we felt a need to give these topics a chapter all their own. Other new topics are sprinkled throughout the book. For the first time we have included PROC REPORT. In addition, we’ve expanded our coverage of the SAS Explorer window, the IMPORT and EXPORT Wizards, Dynamic Data Exchange (DDE), direct-referencing of SAS data sets, and PROC TABULATE. We’ve added more system options, and a section on advanced input with the @’character’ column pointer and the colon modifier. Most of the features in this edition are available with SAS 8.2; a few are new with SAS 9 or SAS 9.1. We have tried to point out whenever a feature is new. So unless otherwise noted, you can assume that everything in this book is available in SAS 8.2. Here, listed by section, are the new topics: The Output Delivery System Section Feature 5.1 Basic concepts for understanding ODS. 5.2 ODS TRACE and ODS SELECT statements allow you to choose which parts of output will be printed. 5.3 ODS OUTPUT statement allows you to save results from SAS procedures as SAS data sets. 5.4-5.6 HTML, RTF, and PRINTER output can be created using ODS statements. 5.7 Titles and footnotes can be customized using the COLOR=, BCOLOR=, HEIGHT=, JUSTIFY=, FONT=, BOLD, and ITALIC options. 5.8-5.10 STYLE= option in PROC PRINT, PROC REPORT, and PROC TABULATE allows you to control almost any aspect of the appearance of your output. 5.11 Traffic-lighting draws attention to important values in reports by determining the style of a cell based on its value. 5.12 Table of selected style attributes shows some of the most popular features that you can control
Introduction porting data Feature Choices for exporting data are outlined 9.2 Export Wizard is now the topic of a complete section. 94 PROC EXPORT can write files in Microsoft Excel or Microsoft Access formats 9.6 ODS HTML and CSV can be used to create data for other applications. (ODS CSV is new with SAS 9.) Cross-Environment Data Access allows sas to read sas data sets created in other operating environments. PROC REPORT Section Feature 4.17 PROC REPORT allows you to create both detail and summary reports. DEFINE statement in PROC REPORT allows you to specify options for individual variables determining how they will be used in the report 4.19 GROUP and ACROSS usage types can be used to create summary groups in rows or 4.20 BREAK and rbreaK statements add summary breaks to PROC REPORT output Statistics can be requested in a COLUMN statement in PROC REPORT. More on Proc tabulate Feature 4.14 FORMAT=, BOX=, and MISSTEXT= options in PROC TABULATE enhance the 4.15 Changing headers in a TABLE statement in PROC TABULATE creates a more customized look FORMAT= option in a TABLE statement in PROC TABULATE allows you to specify multiple formats for data cells Also new with this edition Feature 1.5,8.9 SAS Enterprise Guide provides a graphical user interface to many of the features of SAs including statistical procedures 1.10 HTML output can be easily created by changing a setting in the Preferences window. HTML results appear in the Results viewer window
Introduction xv Exporting data Section Feature 9.1 Choices for exporting data are outlined. 9.2 Export Wizard is now the topic of a complete section. 9.4 PROC EXPORT can write files in Microsoft Excel or Microsoft Access formats. 9.6 ODS HTML and CSV can be used to create data for other applications. (ODS CSV is new with SAS 9.) 9.7 Cross-Environment Data Access allows SAS to read SAS data sets created in other operating environments. PROC REPORT Section Feature 4.17 PROC REPORT allows you to create both detail and summary reports. 4.18 DEFINE statement in PROC REPORT allows you to specify options for individual variables determining how they will be used in the report. 4.19 GROUP and ACROSS usage types can be used to create summary groups in rows or columns. 4.20 BREAK and RBREAK statements add summary breaks to PROC REPORT output. 4.21 Statistics can be requested in a COLUMN statement in PROC REPORT. More on PROC TABULATE Section Feature 4.14 FORMAT=, BOX=, and MISSTEXT= options in PROC TABULATE enhance the appearance of your output. 4.15 Changing headers in a TABLE statement in PROC TABULATE creates a more customized look. 4.16 FORMAT= option in a TABLE statement in PROC TABULATE allows you to specify multiple formats for data cells. Also new with this edition Section Feature 1.5, 8.9 SAS Enterprise Guide provides a graphical user interface to many of the features of SAS including statistical procedures. 1.10 HTML output can be easily created by changing a setting in the Preferences window. HTML results appear in the Results Viewer window
vi The Little sas Book 1.11, 1.12 SAS Explorer window allows you to create new SAS libraries and display SAs data ets and their properties in a point-and-click environment. ORIENTATION=, RIGHTMARGIN=,, LEFTMARGIN=, TOPMARGIN=, and BOTTOMMARGIN= system options give you more control over how your output looks Import Wizard is now the topic of a complete section. @character column pointer and colon modifier make it possible to read messy raw data such Dynamic Data Exchange is now the topic of a complete section Direct-referencing of permanent SAS data sets is now the topic of a complete Names for user-defined formats can be up to 32 characters long, beginning with SAs 9
xvi The Little SAS Book 1.11, 1.12 SAS Explorer window allows you to create new SAS libraries and display SAS data sets and their properties in a point-and-click environment. 1.13 ORIENTATION=, RIGHTMARGIN=, LEFTMARGIN=, TOPMARGIN=, and BOTTOMMARGIN= system options give you more control over how your output looks. 2.3 Import Wizard is now the topic of a complete section. 2.10 @’character’ column pointer and colon modifier make it possible to read messy raw data such as web logs. 2.18 Dynamic Data Exchange is now the topic of a complete section. 2.21 Direct-referencing of permanent SAS data sets is now the topic of a complete section. 4.7 Names for user-defined formats can be up to 32 characters long, beginning with SAS 9
An honest tale speeds best being plainly told, WILLIAM SHAKESPEARE, KING RICHARD III From King Richard ll by william Shakespeare. Public domain
1 From King Richard III by William Shakespeare. Public domain. ‘‘ ’’ An honest tale speeds best being plainly told. WILLIAM SHAKESPEARE, KING RICHARD III