English
资源说明：Table of Contents
Course Description...................................................................................................................... vi
Prerequisites ...............................................................................................................................vii
Chapter 1 Introduction .......................................................................................... 1-1
1.1 Introduction of Course Topics..........................................................................................1-3
1.2 Measuring Efficiencies ....................................................................................................1-5
1.3 SAS Processing..............................................................................................................1-19
1.4 Controlling Memory and I/O Resources........................................................................1-23
1.5 Solutions to Exercises....................................................................................................1-37
Chapter 2 Accessing Observations...................................................................... 2-1
2.1 Introduction......................................................................................................................2-3
2.2 Creating a Sample Data Set .............................................................................................2-7
2.3 Creating and Using an Index..........................................................................................2-36
2.4 Solutions to Exercises....................................................................................................2-71
Chapter 3 Combining Data Horizontally............................................................... 3-1
3.1 Joining Data Sets by Value ..............................................................................................3-3
3.2 Combining Summary and Detail Data...........................................................................3-37
3.3 Using an Index to Combine Data...................................................................................3-56
3.4 Updating Data ................................................................................................................3-72
3.5 Combining Summary and Detail Data Using Two SET Statements (Self-Study) .........3-93
3.6 Solutions to Exercises..................................................................................................3-106
iv For Your Information
Chapter 4 Using Lookup Tables to Match Data................................................... 4-1
4.1 Introduction to Lookup Techniques .................................................................................4-3
4.2 Using Arrays as Lookup Tables .......................................................................................4-6
4.3 Using Hash Objects as Lookup Tables...........................................................................4-43
4.4 Using Formats as Lookup Tables...................................................................................4-77
4.5 Transposing Data to Create a Lookup Table ...............................................................4-108
4.6 Solutions to Exercises..................................................................................................4-119
Chapter 5 Combining Data Vertically ................................................................... 5-1
5.1 Appending SAS Data Sets ...............................................................................................5-3
5.2 Appending Raw Data Files ............................................................................................5-26
5.3 Solutions to Exercises....................................................................................................5-52
Chapter 6 BY-Group Processing and Sorting ..................................................... 6-1
6.1 Introduction......................................................................................................................6-3
6.2 Eliminating Duplicates.....................................................................................................6-5
6.3 Sorting Resources ..........................................................................................................6-16
6.4 Choosing the Right Sort Routine (Self-Study) ..............................................................6-31
6.5 Alternatives to Sorting ...................................................................................................6-37
6.6 Solutions to Exercises....................................................................................................6-65
Chapter 7 Controlling Data Storage Space.......................................................... 7-1
7.1 Introduction......................................................................................................................7-3
7.2 Reducing the Length of Numeric Variables.....................................................................7-6
7.3 Compressing Data Files .................................................................................................7-14
7.4 Creating a DATA Step View...........................................................................................7-28
For Your Information v
7.5 Solutions to Exercises....................................................................................................7-43
Chapter 8 Utilizing Best Practices to Improve Efficiency .................................. 8-1
8.1 Introduction......................................................................................................................8-3
8.2 Executing Only Necessary Statements ............................................................................8-7
8.3 Eliminating Unnecessary Passes through the Data ........................................................8-14
8.4 Reading and Writing Only Essential Data .....................................................................8-20
8.5 Networking Efficiency Considerations (Self-Study) .....................................................8-34
Chapter 9 Using the Scalable Performance Data Engine (Self-Study).............. 9-1
9.1 Introduction to the Scalable Performance Data Engine ...................................................9-3
9.2 Creating SPD Engine Tables..........................................................................................9-10
9.3 Using the SPD Engine Efficiently .................................................................................9-23
9.4 SPD Engine LIBNAME Statement Options List...........................................................9-28
Chapter 10 Additional Topics (Self-Study)........................................................... 10-1
10.1 Modifying SAS Data Sets in Place ................................................................................10-3
10.2 Creating Generation Data Sets.....................................................................................10-29
10.3 Creating Integrity Constraints......................................................................................10-50
10.4 Creating and Using Audit Trails ..................................................................................10-69
10.5 Working with Perl Regular Expressions ......................................................................10-81
10.6 Solutions to Exercises..................................................................................................10-97
Appendix A Index ..................................................................................................... A-1
本源码包内暂不包含可直接显示的源代码文件，请下载源码包。
