The Little SAS Book

Lora D. Delwiche, Susan J. Slaughter

Description

A classic that just keeps getting better, The Little SAS Book is essential for anyone learning SAS programming. Lora Delwiche and Susan Slaughter offer a user-friendly approach so that readers can quickly and easily learn the most commonly used features of the SAS language. Each topic is presented in a self-contained, two-page layout complete with examples and graphics.
Nearly every section has been revised to ensure that the sixth edition is fully up-to-date. This edition is also interface-independent, written for all SAS programmers whether they use SAS Studio, SAS Enterprise Guide, or the SAS windowing environment. New sections have been added covering PROC SQL, iterative DO loops, DO WHILE and DO UNTIL statements, %DO statements, using variable names with special characters, the ODS EXCEL destination, and the XLSX LIBNAME engine.
This title belongs on every SAS programmer's bookshelf. It's a resource not just to get you started, but one you will return to as you continue to improve your programming skills.

Sujets

• COMPUTERS
• General officer
• Mathematics
• Computer programming
• General

Informations

• Publié par: SAS Institute
• Date de parution: 11 octobre 2019
• Nombre de lectures: 0
• EAN13: 9781642953435
• Langue: English
• Poids de l'ouvrage: 18 Mo

Extrait

The correct bibliographic citation for this manual is as follows: Delwiche, Lora D., and Susan J. Slaughter. 2019. The Little SAS Book: A Primer, Sixth Edition . Cary, NC: SAS Institute Inc.
The Little SAS Book: A Primer, Sixth Edition
Copyright 2019, SAS Institute Inc., Cary, NC, USA
ISBN 978-1-64295-616-0 (Hardcover) ISBN 978-1-64295-283-4 (Paperback) ISBN 978-1-64295-342-8 (Web PDF) ISBN 978-1-64295-343-5 (EPUB) ISBN 978-1-64295-344-2 (Kindle)
All rights reserved. Produced in the United States of America.
For 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 Inc.
For a Web download or e-book: Your use of this publication shall be governed by the terms established by the vendor at the time you acquire this publication.
The 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 appreciated.
U.S. Government Restricted Rights Notice: Use, duplication, or disclosure of this software and related documentation by the U.S. government is subject to the Agreement with SAS Institute and the restrictions set forth in FAR 52.227-19, Commercial Computer Software-Restricted Rights (June 1987).
SAS Institute Inc., SAS Campus Drive, Cary, North Carolina 27513-2414
October 2019
SAS Institute Inc. provides a complete selection of books and electronic products to help customers use SAS software to its fullest potential. For more information about our e-books, e-learning products, CDs, and hard-copy books, visit the SAS Books Web site at support.sas.com/bookstore or call 1-800-727-3228.
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 registration.
Other brand and product names are registered trademarks or trademarks of their respective companies.
Contents




Acknowledgments
Introducing SAS Software
About This Book
About These Authors

Chapter 1 Getting Started Using SAS Software
1.1 The SAS Language
1.2 SAS Data Sets
1.3 DATA and PROC Steps
1.4 The DATA Step s Built-in Loop
1.5 Choosing a Method for Running SAS
1.6 Reading the SAS Log
1.7 Using SAS System Options
Chapter 2 Accessing Your Data
2.1 Methods for Getting Your Data into SAS
2.2 SAS Data Libraries and Data Sets
2.3 Listing the Contents of a SAS Data Set
2.4 Reading Excel Files with the IMPORT Procedure
2.5 Accessing Excel Files Using the XLSX LIBNAME Engine
2.6 Reading Delimited Files with the IMPORT Procedure
2.7 Telling SAS Where to Find Your Raw Data
2.8 Reading Raw Data Separated by Spaces
2.9 Reading Raw Data Arranged in Columns
2.10 Reading Raw Data Not in Standard Format
2.11 Selected Informats
2.12 Mixing Input Styles
2.13 Reading Messy Raw Data
2.14 Reading Multiple Lines of Raw Data per Observation
2.15 Reading Multiple Observations per Line of Raw Data
2.16 Reading Part of a Raw Data File
2.17 Controlling Input with Options in the INFILE Statement
2.18 Reading Delimited Files with the DATA Step
Chapter 3 Working with Your Data
3.1 Using the DATA Step to Modify Data
3.2 Creating and Modifying Variables
3.3 Using SAS Functions
3.4 Selected SAS Character Functions
3.5 Selected SAS Numeric Functions
3.6 Using IF-THEN and DO Statements
3.7 Grouping Observations with IF-THEN/ELSE Statements
3.8 Subsetting Your Data in a DATA Step
3.9 Subsetting Your Data Using PROC SQL
3.10 Writing Multiple Data Sets Using OUTPUT Statements
3.11 Making Several Observations from One Using OUTPUT Statements
3.12 Using Iterative DO, DO WHILE, and DO UNTIL Statements
3.13 Working with SAS Dates
3.14 Selected Date Informats, Functions, and Formats
3.15 Using RETAIN and Sum Statements
3.16 Simplifying Programs with Arrays
3.17 Using Shortcuts for Lists of Variable Names
3.18 Using Variable Names with Special Characters
Chapter 4 Sorting, Printing, and Summarizing Your Data
4.1 Using SAS Procedures
4.2 Subsetting in Procedures with the WHERE Statement
4.3 Sorting Your Data with PROC SORT
4.4 Changing the Sort Order for Character Data
4.5 Printing Your Data with PROC PRINT
4.6 Changing the Appearance of DataValues with Formats
4.7 Selected Standard Formats
4.8 Creating Your Own Formats with PROC FORMAT
4.9 Writing a Report to a Text File
4.10 Summarizing Your Data Using PROC MEANS
4.11 Writing Summary Statistics to a SAS Data Set
4.12 Producing One-Way Frequencies with PROC FREQ
4.13 Producing Crosstabulations with PROC FREQ
4.14 Grouping Data with User-Defined Formats
4.15 Producing Tabular Reports with PROC TABULATE
4.16 Adding Statistics to PROC TABULATE Output
4.17 Enhancing the Appearance of PROC TABULATE Output
4.18 Changing Headers in PROC TABULATE Output
4.19 Producing Simple Output with PROC REPORT
4.20 Using DEFINE Statements in PROC REPORT
4.21 Creating Summary Reports with PROC REPORT
4.22 Adding Summary Breaks to PROC REPORT Output
4.23 Adding Statistics to PROC REPORT Output
4.24 Adding Computed Variables to PROC REPORT Output
Chapter 5 Enhancing Your Output with ODS
5.1 Concepts of the Output Delivery System
5.2 Creating HTML Output
5.3 Creating RTF Output
5.4 Creating PDF Output
5.5 Creating Text Output
5.6 Customizing Titles and Footnotes
5.7 Customizing PROC PRINT with the STYLE= Option
5.8 Customizing PROC REPORT with the STYLE= Option
5.9 Customizing PROC TABULATE with the STYLE= Option
5.10 Adding Trafficlighting to Your Output
5.11 Selected Style Attributes
5.12 Tracing and Selecting Procedure Output
5.13 Creating SAS Data Sets from Procedure Output
Chapter 6 Modifying and Combining SAS Data Sets
6.1 Stacking Data Sets Using the SET Statement
6.2 Interleaving Data Sets Using the SET Statement
6.3 Combining Data Sets Using a One-to-One Match Merge
6.4 Combining Data Sets Using a One-to-Many Match Merge
6.5 Using PROC SQL to Join Data Sets
6.6 Merging Summary Statistics with the Original Data
6.7 Combining a Grand Total with the Original Data
6.8 Adding Summary Statistics to Data Using PROC SQL
6.9 Updating a Master Data Set with Transactions
6.10 Using SAS Data Set Options
6.11 Tracking and Selecting Observations with the IN= Option
6.12 Selecting Observations with the WHERE= Option
6.13 Changing Observations to Variables Using PROC TRANSPOSE
6.14 Using SAS Automatic Variables
Chapter 7 Writing Flexible Code with the SAS Macro Facility
7.1 Macro Concepts
7.2 Substituting Text with Macro Variables
7.3 Concatenating Macro Variables with Other Text
7.4 Creating Modular Code with Macros
7.5 Adding Parameters to Macros
7.6 Writing Macros with Conditional Logic
7.7 Using %DO Loops in Macros
7.8 Writing Data-Driven Programs with CALL SYMPUTX
7.9 Writing Data-Driven Programs with PROC SQL
7.10 Debugging Macro Errors
Chapter 8 Visualizing Your Data
8.1 Concepts of ODS Graphics
8.2 Creating Bar Charts with PROC SGPLOT
8.3 Creating Histograms and Density Curves with PROC SGPLOT
8.4 Creating Box Plots with PROC SGPLOT
8.5 Creating Scatter Plots with PROC SGPLOT
8.6 Creating Series Plots with PROC SGPLOT
8.7 Creating Fitted Curves with PROC SGPLOT
8.8 Controlling Axes and Reference Lines in PROC SGPLOT
8.9 Controlling Legends and Insets in PROC SGPLOT
8.10 Customizing Graph Attributes in PROC SGPLOT
8.11 Creating Paneled Graphs with PROC SGPANEL
8.12 Specifying Image Properties and Saving Graphics Output
Chapter 9 Using Basic Statistical Procedures
9.1 Examining the Distribution of Data with PROC UNIVARIATE
9.2 Creating Statistical Graphics with PROC UNIVARIATE
9.3 Producing Statistics with PROC MEANS
9.4 Testing Means with PROC TTEST
9.5 Creating Statistical Graphics with PROC TTEST 258
9.6 Testing Categorical Data with PROC FREQ
9.7 Creating Statistical Graphics with PROC FREQ
9.8 Examining Correlations with PROC CORR
9.9 Creating Statistical Graphics with PROC CORR
9.10 Using PROC REG for Simple Regression Analysis
9.11 Creating Statistical Graphics with PROC REG
9.12 Using PROC ANOVA for One-Way Analysis of Variance
9.13 Reading the Output of PROC ANOVA
Chapter 10 Exporting Your Data
10.1 Methods for Exporting Your Data
10.2 Writing Delimited Files with the EXPORT Procedure
10.3 Writing Delimited Files Using ODS
10.4 Writing Microsoft Excel Files with the EXPORT Procedure
10.5 Writing Microsoft Excel Files Using ODS
10.6 Writing Raw Data Files with the DATA Step
Chapter 11 Debugging Your SAS Programs
11.1 Writing SAS Programs That Work
11.2 Fixing Programs That Don t Work
11.3 Searching for the Missing Semicolon