【书名】 SAS Programming II:Manipulating Data with the DATA Step
【作者】SAS Publishing
【出版社】SAS Publishing
【版本】1 edition
【出版日期】2007
【文件格式】PDF
【文件大小】2.87MB
【页数】635
【ISBN出版号】978-1-59994-397-8
【资料类别】笔记
【市面定价】$47.87
【扫描版还是影印版】清晰版
【是否缺页】无
【关键词】SAS Certification,SAS Programming II
【内容简介】This course is for those who need to learn SAS DATA step programming techniques for processing, controlling, and manipulating SAS data sets. The course builds on the concepts that are presented in the SAS Programming I: Essentials course and is not recommended for beginning SAS software users.
This course can help prepare you for the following certification exam(s): SAS Base Programming Exam for SAS 9.
Learn how to
control SAS data set input and output
combine SAS data sets
summarize, read, and write different types of data
perform DO loop and SAS array processing
transform character, numeric, and date variables.
【目录】
Table of Contents
Course Description..................................................................................................................... vi
Prerequisites ...............................................................................................................................vii
Chapter 1 Introduction .......................................................................................... 1-1
1.1 Overview.........................................................................................................................1-3
1.2 Review of SAS Basics .....................................................................................................1-9
1.3 Review of DATA Step Processing..................................................................................1-19
1.4 Review of Displaying SAS Data Sets............................................................................1-34
1.5 Working with Existing SAS Data Sets...........................................................................1-43
1.6 Prerequisite Syntax (Self-Study)....................................................................................1-67
1.7 Navigating the SAS Windowing Environment (Self-Study) .........................................1-70
Chapter 2 Controlling Input and Output .............................................................. 2-1
2.1 Outputting Multiple Observations ...................................................................................2-3
2.2 Writing to Multiple SAS Data Sets................................................................................2-20
2.3 Selecting Variables and Observations ............................................................................2-27
2.4 Writing to an External File.............................................................................................2-45
2.5 Solutions to Exercises....................................................................................................2-68
Chapter 3 Summarizing Data ................................................................................ 3-1
3.1 Creating an Accumulating Total Variable ........................................................................3-3
3.2 Accumulating Totals for a Group of Data......................................................................3-17
3.3 Solutions to Exercises....................................................................................................3-43
Chapter 4 Reading and Writing Different Types of Data..................................... 4-1
4.1 Reading Delimited Raw Data Files..................................................................................4-3
4.2 Controlling when a Record Loads .................................................................................4-46
4.3 Reading Hierarchical Raw Data Files............................................................................4-88
4.4 Solutions to Exercises..................................................................................................4-154
Chapter 5 Data Transformations........................................................................... 5-1
5.1 Introduction.....................................................................................................................5-3
5.2 Manipulating Character Values........................................................................................5-8
5.3 Manipulating Numeric Values .......................................................................................5-55
5.4 Manipulating Numeric Values Based on Dates..............................................................5-65
5.5 Converting Variable Type ..............................................................................................5-70
5.6 Solutions to Exercises....................................................................................................5-95
Chapter 6 Debugging Techniques (Self-Study)................................................... 6-1
6.1 Using the PUT Statement.................................................................................................6-3
6.2 Using the DEBUG Option .............................................................................................6-15
Chapter 7 Processing Data Iteratively.................................................................. 7-1
7.1 DO Loop Processing........................................................................................................7-3
7.2 SAS Array Processing....................................................................................................7-37
7.3 Using SAS Arrays..........................................................................................................7-52
7.4 Solutions to Exercises....................................................................................................7-75
Chapter 8 Combining SAS® Data Sets ................................................................. 8-1
8.1 Match-Merging Two or More SAS Data Sets..................................................................8-3
8.2 Simple Joins Using the SQL Procedure (Self-Study) ....................................................8-27
8.3 Solutions to Exercises....................................................................................................8-41
Chapter 9 Learning More....................................................................................... 9-1
9.1 Where Do I Go From Here?.............................................................................................9-3
9.2 SAS Resources.................................................................................................................9-5
Appendix A Index ..................................................................................................... A-1
【原创书评】准备SAS认证的官方课堂笔记的第二本(总共有三本),总共635页,不同于06版本的489页。