SQL Processing with SAS - Course Notes (PDF)-经管之家官网！

免费学术公开课,扫码加入

【书名】SQL Processing with SAS® Course Notes
【作者】 Jens Dahl Mikkelsen
【出版社】 SAS Institute
【版本】1
【出版日期】2006
【文件格式】PDF
【文件大小】 2.4M
【页数】 312
【ISBN出版号】 1-59994-251-8
【资料类别】教程，

【关键词】SAS, SQL, SAS Institute, SAS Publishing
【内容简介】 本书是SAS－INSTITUTE 培训用的教材。内容全面，系统，简结。适用于出学SQL者和准备考证书的人使用。

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.
【目录】 Table of Contents

Course Description................................. vi

Prerequisites ............................................vii

Chapter 1 Introduction

1.1 Structured Query Language ..............1-3

1.2 SAS Functions ....................................1-8

1.3 Case Study ..........................................1-14

1.4 Chapter Summary ............................1-17

Chapter 2 Basic Queries

2.1 Overview of the SQL Procedure .......2-3

2.2 Specifying Columns......................... 2-11

2.3 Specifying Rows...............................2-17

2.4 Presenting Data .................................2-31

2.5 Summarizing Data ............................2-41

2.6 Subqueries.........................................2-51

2.7 Chapter Summary ............................2-76

2.8 Solutions to Exercises.......................2-77

Chapter 3 Combining Tables

3.1 Overview............................................3-3

3.2 Joins ..................................................3-5

3.3 Complex Joins..................................3-27

3.4 Set Operators...................................3-46

iv For Your Information

3.5 Chapter Summary ..........................3-77

3.6 Solutions to Exercises....................3-79

Chapter 4 Creating and Modifying Tables and Views

4.1 Creating Tables ...............................4-3

4.2 Creating Views................................4-20

4.3 Creating Indexes ............................4-31

4.4 Maintaining Tables...................4-45

4.5 Chapter Summary .........................4-60

4.6 Solutions to Exercises..........................4-63

Chapter 5 Additional SQL Features............. 5-1

5.1 Setting SQL Procedure Options..............5-3

5.2 Dictionary Tables and Views ...............5-9

5.3 Interfacing PROC SQL with Macro Language (Optional) .......5-18

5.4 Program Testing and Performance .........5-29

5.5 Chapter Summary ....................................5-34

Appendix A Overview of Table and Column Names ......... A-1

A.1 Table and Column Names Sorted by Column Names..........A-3

Appendix B Overview of Table and Column Names ....... B-1

B.1 Table and Column Names Sorted by Table Name ........... B-3

Appendix C Table Listings................. C-1

C.1 Partial Table Listings ...................... C-3

For Your Information v

Appendix D Index .................... D-1

「经管之家」APP：经管人学习、答疑、交友，就上经管之家！
免流量费下载资料----在经管之家app可以下载论坛上的所有资源，并且不额外收取下载高峰期的论坛币。
涵盖所有经管领域的优秀内容----覆盖经济、管理、金融投资、计量统计、数据分析、国贸、财会等专业的学习宝库，各类资料应有尽有。
来自五湖四海的经管达人----已经有上千万的经管人来到这里，你可以找到任何学科方向、有共同话题的朋友。
经管之家（原人大经济论坛），跨越高校的围墙，带你走进经管知识的新世界。
扫描下方二维码下载并注册APP