<p></p><p> </p><p>【书名】SQL Processing with SAS&reg; Course Notes<br/>【作者】&nbsp; Jens Dahl Mikkelsen<br/>【出版社】 SAS Institute<br/>【版本】1<br/>【出版日期】2006<br/>【文件格式】PDF &nbsp;<br/>【文件大小】 2.4M<br/>【页数】&nbsp;&nbsp;&nbsp; 312<br/>【ISBN出版号】&nbsp; 1-59994-251-8<br/>【资料类别】教程，</p><p>【关键词】SAS, SQL, SAS Institute, SAS Publishing<br/>【内容简介】 本书是SAS－INSTITUTE 培训用的教材。内容全面，系统，简结。适用于出学SQL者和准备考证书的人使用。</p><p></p><p>This intermediate course focuses on using SQL as a data query and manipulation tool. You learn to use the SQL procedure as a data retrieval tool within SAS programs. Specifically, you learn how to perform queries on data; retrieve data from multiple tables; create views, indexes, and tables; and update or delete values in existing tables and views. Using features of the SQL procedure to debug, test, and optimize the performance of SQL queries is also discussed.<br/>【目录】 &nbsp;Table of Contents</p><p>Course Description................................. vi</p><p>Prerequisites ............................................vii</p><p>Chapter 1 Introduction </p><p>1.1 Structured Query Language ..............1-3</p><p>1.2 SAS Functions ....................................1-8</p><p>1.3 Case Study ..........................................1-14</p><p>1.4 Chapter Summary ............................1-17</p><p>Chapter 2 Basic Queries </p><p>2.1 Overview of the SQL Procedure .......2-3</p><p>2.2 Specifying Columns......................... 2-11</p><p>2.3 Specifying Rows...............................2-17</p><p>2.4 Presenting Data .................................2-31</p><p>2.5 Summarizing Data ............................2-41</p><p>2.6 Subqueries.........................................2-51</p><p>2.7 Chapter Summary ............................2-76</p><p>2.8 Solutions to Exercises.......................2-77</p><p>Chapter 3 Combining Tables</p><p>3.1 Overview............................................3-3</p><p>3.2 Joins ..................................................3-5</p><p>3.3 Complex Joins..................................3-27</p><p>3.4 Set Operators...................................3-46</p><p>iv For Your Information</p><p>3.5 Chapter Summary ..........................3-77</p><p>3.6 Solutions to Exercises....................3-79</p><p>Chapter 4 Creating and Modifying Tables and Views</p><p>4.1 Creating Tables ...............................4-3</p><p>4.2 Creating Views................................4-20</p><p>4.3 Creating Indexes ............................4-31</p><p>4.4 Maintaining Tables...................4-45</p><p>4.5 Chapter Summary .........................4-60</p><p>4.6 Solutions to Exercises..........................4-63</p><p>Chapter 5 Additional SQL Features............. 5-1</p><p>5.1 Setting SQL Procedure Options..............5-3</p><p>5.2 Dictionary Tables and Views ...............5-9</p><p>5.3 Interfacing PROC SQL with Macro Language (Optional) .......5-18</p><p>5.4 Program Testing and Performance .........5-29</p><p>5.5 Chapter Summary ....................................5-34</p><p>Appendix A Overview of Table and Column Names ......... A-1</p><p>A.1 Table and Column Names Sorted by Column Names..........A-3</p><p>Appendix B Overview of Table and Column Names ....... B-1</p><p>B.1 Table and Column Names Sorted by Table Name ........... B-3</p><p>Appendix C Table Listings................. C-1</p><p>C.1 Partial Table Listings ...................... C-3</p><p>For Your Information v</p><p>Appendix D Index .................... D-1</p><p></p>

[此贴子已经被作者于2009-1-7 0:31:06编辑过]