第1页 / 共377页
第2页 / 共377页
第3页 / 共377页
第4页 / 共377页
第5页 / 共377页
第6页 / 共377页
第7页 / 共377页
第8页 / 共377页
The Little Sas Book A Primer.Fifth Edition.pdf
Acknowledgments
Introducing SAS Software
About This Book
What’s New
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 Mode for Submitting SAS Programs
1.6 Windows and Commands in the SAS Windowing Environment
1.7 Submitting a Program in the SAS Windowing Environment
1.8 Reading the SAS Log
1.9 Viewing Your Results
1.10 SAS Data Libraries
1.11 Viewing Data Sets in the Viewtable Window
1.12 Viewing the Properties of Data Sets with SAS Explorer
1.13 Using SAS System Options
Chapter 2 Getting Your Data into SAS
2.1 Methods for Getting Your Data into SAS
2.2 Entering Data with the Viewtable Window
2.3 Reading Files with the Import Wizard
2.4 Telling SAS Where to Find Your Raw Data
2.5 Reading Raw Data Separated by Spaces
2.6 Reading Raw Data Arranged in Columns
2.7 Reading Raw Data Not in Standard Format
2.8 Selected Informats
2.9 Mixing Input Styles
2.10 Reading Messy Raw Data
2.11 Reading Multiple Lines of Raw Data per Observation
2.12 Reading Multiple Observations per Line of Raw Data
2.13 Reading Part of a Raw Data File
2.14 Controlling Input with Options in the INFILE Statement
2.15 Reading Delimited Files with the DATA Step
2.16 Reading Delimited Files with the IMPORT Procedure
2.17 Reading Excel Files with the IMPORT Procedure
2.18 Temporary versus Permanent SAS Data Sets
2.19 Using Permanent SAS Data Sets with LIBNAME Statements
2.20 Using Permanent SAS Data Sets by Direct Referencing
2.21 Listing the Contents of a SAS Data Set
Chapter 3 Working with Your Data
3.1 Creating and Redefining Variables
3.2 Using SAS Functions
3.3 Selected SAS Character Functions
3.4 Selected SAS Numeric Functions
3.5 Using IF-THEN Statements
3.6 Grouping Observations with IF-THEN/ELSE Statements
3.7 Subsetting Your Data
3.8 Working with SAS Dates
3.9 Selected Date Informats, Functions, and Formats
3.10 Using the RETAIN and Sum Statements
3.11 Simplifying Programs with Arrays
3.12 Using Shortcuts for Lists of Variable Names
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 Printed Values with Formats
4.7 Selected Standard Formats
4.8 Creating Your Own Formats Using PROC FORMAT
4.9 Writing Simple Custom Reports
4.10 Summarizing Your Data Using PROC MEANS
4.11 Writing Summary Statistics to a SAS Data Set
4.12 Counting Your Data with PROC FREQ
4.13 Producing Tabular Reports with PROC TABULATE
4.14 Adding Statistics to PROC TABULATE Output
4.15 Enhancing the Appearance of PROC TABULATE Output
4.16 Changing Headers in PROC TABULATE Output
4.17 Specifying Multiple Formats for Data Cells in PROC
TABULATE Output
4.18 Producing Simple Output with PROC REPORT
4.19 Using DEFINE Statements in PROC REPORT
4.20 Creating Summary Reports with PROC REPORT
4.21 Adding Summary Breaks to PROC REPORT Output
4.22 Adding Statistics to PROC REPORT Output
4.23 Adding Computed Variables to PROC REPORT Output
4.24 Grouping Data in Procedures with User-Defined Formats
Chapter 5 Enhancing Your Output with ODS
5.1 Concepts of the Output Delivery System
5.2 Tracing and Selecting Procedure Output
5.3 Creating SAS Data Sets from Procedure Output
5.4 Creating Text Output
5.5 Creating HTML Output
5.6 Creating RTF Output
5.7 Creating PDF Output
5.8 Customizing Titles and Footnotes
5.9 Customizing PROC PRINT with the STYLE= Option
5.10 Customizing PROC REPORT with the STYLE= Option
5.11 Customizing PROC TABULATE with the STYLE= Option
5.12 Adding Traffic-Lighting to Your Output
5.13 Selected Style Attributes
Chapter 6 Modifying and Combining SAS Data Sets
6.1 Modifying a Data Set Using the SET Statement
6.2 Stacking Data Sets Using the SET Statement
6.3 Interleaving Data Sets Using the SET Statement
6.4 Combining Data Sets Using a One-to-One Match Merge
6.5 Combining Data Sets Using a One-to-Many Match Merge
6.6 Merging Summary Statistics with the Original Data
6.7 Combining a Grand Total with the Original Data
6.8 Updating a Master Data Set with Transactions
6.9 Writing Multiple Data Sets Using the OUTPUT Statement
6.10 Making Several Observations from One Using the
OUTPUT Statement
6.11 Using SAS Data Set Options
6.12 Tracking and Selecting Observations with the IN= Option
6.13 Selecting Observations with the WHERE= Option
6.14 Changing Observations to Variables Using PROC TRANSPOSE
6.15 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 Writing Data-Driven Programs with CALL SYMPUT
7.8 Debugging Macro Errors
Chapter 8 Visualizing Your Data
8.1 Concepts of ODS Graphics
8.2 Creating Bar Charts
8.3 Creating Histograms and Density Curves
8.4 Creating Box Plots
8.5 Creating Scatter Plots
8.6 Creating Series Plots
8.7 Creating Fitted Curves
8.8 Controlling Axes and Reference Lines
8.9 Controlling Legends and Insets
8.10 Customizing Graph Attributes
8.11 Creating Paneled Graphs
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
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 Files Using the Export Wizard
10.3 Writing Delimited Files with the EXPORT Procedure
10.4 Writing Microsoft Excel Files with the EXPORT Procedure
10.5 Writing Raw Data Files with the DATA Step
10.6 Writing Delimited and HTML Files Using ODS
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
11.4 Note: INPUT Statement Reached Past the End of a Line
11.5 Note: Lost Card
11.6 Note: Invalid Data
11.7 Note: Missing Values Were Generated
11.8 Note: Numeric Values Have Been Converted to
Character (or Vice Versa)
11.9 DATA Step Produces Wrong Results but No Error Message
11.10 Error: Invalid Option, Error: The Option Is Not
Recognized, or Error: Statement Is Not Valid
11.11 Note: Variable Is Uninitialized or Error:
Variable Not Found
11.12 SAS Truncates a Character Variable
11.13 SAS Stops in the Middle of a Program
11.14 SAS Runs Out of Memory or Disk Space
Appendix Coming to SAS from SQL
Index
A Programming
Approach
a
F
I
p
F T H
r
i m e
r
E D I T I O N
Lora D. Delwiche and Susan J. Slaughter
Delwiche, Lora D., and Susan J. Slaughter. The Little SAS® Book: A Primer, Fifth Edition. Copyright © 2012, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED. For additional SAS resources, visit support.sas.com/bookstore.
The correct bibliographic citation for this manual is as follows: Delwiche, Lora D., and Susan J. Slaughter.
2012. The Little SAS® Book: A Primer, Fifth Edition. Cary, NC: SAS Institute Inc.
The Little SAS® Book: A Primer, Fifth Edition
Copyright © 2012, SAS Institute Inc., Cary, NC, USA
ISBN 978-1-61290-400-9 (electronic book)
ISBN 978-1-61290-343-9
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
1st printing, October 2012
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.
Delwiche, Lora D., and Susan J. Slaughter. The Little SAS® Book: A Primer, Fifth Edition. Copyright © 2012, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED. For additional SAS resources, visit support.sas.com/bookstore.
Contents
Acknowledgments ix
Introducing SAS Software x
About This Book xi
What’s New xiv
Chapter 1 Getting Started Using SAS Software 1
1.1 The SAS Language 2
1.2 SAS Data Sets 4
1.3 DATA and PROC Steps 6
1.4 The DATA Step’s Built-in Loop 8
1.5 Choosing a Mode for Submitting SAS Programs 10
1.6 Windows and Commands in the SAS Windowing Environment 12
1.7 Submitting a Program in the SAS Windowing Environment 14
1.8 Reading the SAS Log 16
1.9 Viewing Your Results 18
1.10 SAS Data Libraries 20
1.11 Viewing Data Sets in the Viewtable Window 22
1.12 Viewing the Properties of Data Sets with SAS Explorer 24
1.13 Using SAS System Options 26
Chapter 2 Getting Your Data into SAS 29
2.1 Methods for Getting Your Data into SAS 30
2.2 Entering Data with the Viewtable Window 32
2.3 Reading Files with the Import Wizard 34
2.4 Telling SAS Where to Find Your Raw Data 36
2.5 Reading Raw Data Separated by Spaces 38
2.6 Reading Raw Data Arranged in Columns 40
2.7 Reading Raw Data Not in Standard Format 42
2.8 Selected Informats 44
Delwiche, Lora D., and Susan J. Slaughter. The Little SAS® Book: A Primer, Fifth Edition. Copyright © 2012, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED. For additional SAS resources, visit support.sas.com/bookstore.
iv Contents
2.9 Mixing Input Styles 46
2.10 Reading Messy Raw Data 48
2.11 Reading Multiple Lines of Raw Data per Observation 50
2.12 Reading Multiple Observations per Line of Raw Data 52
2.13 Reading Part of a Raw Data File 54
2.14 Controlling Input with Options in the INFILE Statement 56
2.15 Reading Delimited Files with the DATA Step 58
2.16 Reading Delimited Files with the IMPORT Procedure 60
2.17 Reading Excel Files with the IMPORT Procedure 62
2.18 Temporary versus Permanent SAS Data Sets 64
2.19 Using Permanent SAS Data Sets with LIBNAME Statements 66
2.20 Using Permanent SAS Data Sets by Direct Referencing 68
2.21 Listing the Contents of a SAS Data Set 70
Chapter 3 Working with Your Data 73
3.1 Creating and Redefining Variables 74
3.2 Using SAS Functions 76
3.3 Selected SAS Character Functions 78
3.4 Selected SAS Numeric Functions 80
3.5 Using IF-THEN Statements 82
3.6 Grouping Observations with IF-THEN/ELSE Statements 84
3.7 Subsetting Your Data 86
3.8 Working with SAS Dates 88
3.9 Selected Date Informats, Functions, and Formats 90
3.10 Using the RETAIN and Sum Statements 92
3.11 Simplifying Programs with Arrays 94
3.12 Using Shortcuts for Lists of Variable Names 96
Chapter 4 Sorting, Printing, and Summarizing Your Data 99
4.1 Using SAS Procedures 100
4.2 Subsetting in Procedures with the WHERE Statement 102
4.3 Sorting Your Data with PROC SORT 104
4.4 Changing the Sort Order for Character Data 106
4.5 Printing Your Data with PROC PRINT 108
Delwiche, Lora D., and Susan J. Slaughter. The Little SAS® Book: A Primer, Fifth Edition. Copyright © 2012, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED. For additional SAS resources, visit support.sas.com/bookstore.
Contents v
Output 132
4.6 Changing the Appearance of Printed Values with Formats 110
4.7 Selected Standard Formats 112
4.8 Creating Your Own Formats Using PROC FORMAT 114
4.9 Writing Simple Custom Reports 116
4.10 Summarizing Your Data Using PROC MEANS 118
4.11 Writing Summary Statistics to a SAS Data Set 120
4.12 Counting Your Data with PROC FREQ 122
4.13 Producing Tabular Reports with PROC TABULATE 124
4.14 Adding Statistics to PROC TABULATE Output 126
4.15 Enhancing the Appearance of PROC TABULATE Output 128
4.16 Changing Headers in PROC TABULATE Output 130
4.17 Specifying Multiple Formats for Data Cells in PROC TABULATE
4.18 Producing Simple Output with PROC REPORT 134
4.19 Using DEFINE Statements in PROC REPORT 136
4.20 Creating Summary Reports with PROC REPORT 138
4.21 Adding Summary Breaks to PROC REPORT Output 140
4.22 Adding Statistics to PROC REPORT Output 142
4.23 Adding Computed Variables to PROC REPORT Output 144
4.24 Grouping Data in Procedures with User-Defined Formats 146
Chapter 5 Enhancing Your Output with ODS 149
5.1 Concepts of the Output Delivery System 150
5.2 Tracing and Selecting Procedure Output 152
5.3 Creating SAS Data Sets from Procedure Output 154
5.4 Creating Text Output 156
5.5 Creating HTML Output 158
5.6 Creating RTF Output 160
5.7 Creating PDF Output 162
5.8 Customizing Titles and Footnotes 164
5.9 Customizing PROC PRINT with the STYLE= Option 166
5.10 Customizing PROC REPORT with the STYLE= Option 168
5.11 Customizing PROC TABULATE with the STYLE= Option 170
Delwiche, Lora D., and Susan J. Slaughter. The Little SAS® Book: A Primer, Fifth Edition. Copyright © 2012, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED. For additional SAS resources, visit support.sas.com/bookstore.
vi Contents
5.12 Adding Traffic-Lighting to Your Output 172
5.13 Selected Style Attributes 174
6.1 Modifying a Data Set Using the SET Statement 178
6.2 Stacking Data Sets Using the SET Statement 180
6.3 Interleaving Data Sets Using the SET Statement 182
6.4 Combining Data Sets Using a One-to-One Match Merge 184
6.5 Combining Data Sets Using a One-to-Many Match Merge 186
6.6 Merging Summary Statistics with the Original Data 188
6.7 Combining a Grand Total with the Original Data 190
6.8 Updating a Master Data Set with Transactions 192
6.9 Writing Multiple Data Sets Using the OUTPUT Statement 194
6.10 Making Several Observations from One Using
Chapter 6 Modifying and Combining SAS Data Sets 177
the OUTPUT Statement 196
6.11 Using SAS Data Set Options 198
6.12 Tracking and Selecting Observations with the IN= Option 200
6.13 Selecting Observations with the WHERE= Option 202
6.14 Changing Observations to Variables Using PROC TRANSPOSE 204
6.15 Using SAS Automatic Variables 206
Chapter 7 Writing Flexible Code with the SAS Macro Facility 209
7.1 Macro Concepts 210
7.2 Substituting Text with Macro Variables 212
7.3 Concatenating Macro Variables with Other Text 214
7.4 Creating Modular Code with Macros 216
7.5 Adding Parameters to Macros 218
7.6 Writing Macros with Conditional Logic 220
7.7 Writing Data-Driven Programs with CALL SYMPUT 222
7.8 Debugging Macro Errors 224
Chapter 8 Visualizing Your Data 227
8.1 Concepts of ODS Graphics 228
8.2 Creating Bar Charts 230
8.3 Creating Histograms and Density Curves 232
Delwiche, Lora D., and Susan J. Slaughter. The Little SAS® Book: A Primer, Fifth Edition. Copyright © 2012, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED. For additional SAS resources, visit support.sas.com/bookstore.
Contents vii
8.4 Creating Box Plots 234
8.5 Creating Scatter Plots 236
8.6 Creating Series Plots 238
8.7 Creating Fitted Curves 240
8.8 Controlling Axes and Reference Lines 242
8.9 Controlling Legends and Insets 244
8.10 Customizing Graph Attributes 246
8.11 Creating Paneled Graphs 248
8.12 Specifying Image Properties and Saving Graphics Output 250
Chapter 9 Using Basic Statistical Procedures 253
9.1 Examining the Distribution of Data with PROC UNIVARIATE 254
9.2 Creating Statistical Graphics with PROC UNIVARIATE 256
9.3 Producing Statistics with PROC MEANS 258
9.4 Testing Means with PROC TTEST 260
9.5 Creating Statistical Graphics with PROC TTEST 262
9.6 Testing Categorical Data with PROC FREQ 264
9.7 Creating Statistical Graphics with PROC FREQ 266
9.8 Examining Correlations with PROC CORR 268
9.9 Creating Statistical Graphics with PROC CORR 270
9.10 Using PROC REG for Simple Regression Analysis 272
9.11 Creating Statistical Graphics with PROC REG 274
9.12 Using PROC ANOVA for One-Way Analysis of Variance 276
9.13 Reading the Output of PROC ANOVA 278
Chapter 10 Exporting Your Data 281
10.1 Methods for Exporting Your Data 282
10.2 Writing Files Using the Export Wizard 284
10.3 Writing Delimited Files with the EXPORT Procedure 286
10.4 Writing Microsoft Excel Files with the EXPORT Procedure 288
10.5 Writing Raw Data Files with the DATA Step 290
10.6 Writing Delimited and HTML Files Using ODS 292
Chapter 11 Debugging Your SAS Programs 295
11.1 Writing SAS Programs That Work 296
11.2 Fixing Programs That Don’t Work 298
Delwiche, Lora D., and Susan J. Slaughter. The Little SAS® Book: A Primer, Fifth Edition. Copyright © 2012, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED. For additional SAS resources, visit support.sas.com/bookstore.
相关推荐
2023年江西萍乡中考道德与法治真题及答案.doc
2012年重庆南川中考生物真题及答案.doc
2013年江西师范大学地理学综合及文艺理论基础考研真题.doc
2020年四川甘孜小升初语文真题及答案I卷.doc
2020年注册岩土工程师专业基础考试真题及答案.doc
2023-2024学年福建省厦门市九年级上学期数学月考试题及答案.doc
2021-2022学年辽宁省沈阳市大东区九年级上学期语文期末试题及答案.doc
2022-2023学年北京东城区初三第一学期物理期末试卷及答案.doc
2018上半年江西教师资格初中地理学科知识与教学能力真题及答案.doc
2012年河北国家公务员申论考试真题及答案-省级.doc
2020-2021学年江苏省扬州市江都区邵樊片九年级上学期数学第一次质量检测试题及答案.doc
2022下半年黑龙江教师资格证中学综合素质真题及答案.doc
