没有合适的资源?快使用搜索试试~ 我知道了~
本书深入探讨了SAS高级编程技术,特别是PROC SQL的应用。它不仅涵盖了数据处理、查询优化和宏语言的使用,还详细介绍了如何利用PROC SQL进行数据汇总、分组及复杂查询。书中通过丰富的实例讲解了SAS数据集的操作,如创建、修改和查询表格,以及如何使用SAS宏语言简化编程任务。此外,本书还探讨了如何使用SAS进行数据分析,包括数据清洗、转换和可视化。适合希望提升SAS编程技能的专业人士阅读。
资源推荐
资源详情
资源评论





















The correct bibliographic citation for this manual is as follows: SAS Institute Inc. 2019. SAS® Certified
Professional Prep Guide: Advanced Programming Using SAS® 9.4 Cary, NC: SAS Institute Inc.
SAS® Certified Professional Prep Guide: Advanced Programming Using SAS® 9.4
Copyright © 2019, SAS Institute Inc., Cary, NC, USA
ISBN 978-1-64295-467-8 (Paperback)
ISBN 978-1-64295-469-2 (Epub)
ISBN 978-1-64295-470-8 (Mobi)
ISBN 978-1-64295-468-5 (PDF)
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 License Rights; Restricted Rights: The Software and its documentation is commercial
computer software developed at private expense and is provided with RESTRICTED RIGHTS to the United
States Government. Use, duplication, or disclosure of the Software by the United States Government is
subject to the license terms of this Agreement pursuant to, as applicable, FAR 12.212, DFAR 227.7202-1(a),
DFAR 227.7202-3(a), and DFAR 227.7202-4, and, to the extent required under U.S. federal law, the
minimum restricted rights as set out in FAR 52.227-19 (DEC 2007). If FAR 52.227-19 is applicable, this
provision serves as notice under clause (c) thereof and no other notice is required to be affixed to the Software
or documentation. The Government’s rights in Software and documentation shall be only those set forth in
this Agreement.
SAS Institute Inc., SAS Campus Drive, Cary, NC 27513-2414
October 2019
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 trademarks of their respective companies.
P1:certprpg
Last updated: October 16, 2019

本手册的正确参考文献引用如下:SAS Institute Inc. 2019. SAS® Certified
Professional Prep Guide: Advanced Programming Using SAS® 9.4 北卡罗来纳州卡里:SAS Institute Inc.
SAS®认证专业人员备考指南:使用SAS® 9.4的高级编程
版权所有 © 2019, SAS 研究所股份有限公司,北卡罗来纳州,美国
平装版 ISBN 978-1-64295-467-8 Epu
b版 ISBN 978-1-64295-469-2 Mobi版
ISBN 978-1-64295-470-8 PDF版 ISB
N 978-1-64295-468-5
版权所有。在美国制作。
对于纸质书籍:未经出版商SAS Institute Inc.事先书面许可,不得以任何形式或通过任何手段,包括电
子、机械、复印等方式,复制、存储于检索系统或传输本出版物的任何部分。
对于网络下载或电子书:您使用本出版物的行为应受您获取本出版物时卖方所建立的条款的管辖。
未经出版商许可,通过互联网或其他方式扫描、上传和分发本书是非法的,将受到法律的惩处。请仅
购买授权的电子版,并不要参与或鼓励版权材料的电子盗版行为。感谢您对他人的权利的支持。
美国政府许可权利;限制权利:该软件及其文档是在私人费用下开发的商业计算机软件,美国政府使
用、复制或披露该软件时,根据适用情况,受本协议的许可条款约束,按照联邦采购条例(FAR)12.
212条款、国防联邦采购条例(DFAR)227.7202-1(a)条款、DFAR 227.7202-3(a)条款和DFAR 227.7202
-4条款,以及在必要时根据美国联邦法律规定的最低限制权利,如FAR 52.227-19条款(2007年12月)
。如果适用FAR 52.227-19条款,则本条款作为其中条款(c)项下的通知,无需在软件或文档上附加其
他通知。政府在软件和文档中的权利仅限于本协议中所规定的权利。
SAS 研究所股份有限公司,SAS 校园驱动,卡里,北卡罗来纳州 27513-2414
2019年10月
SAS® 以及所有其他SAS Institute Inc.的产品或服务名称在美国和其他国家均是注册商标或商标。® 表
示在美国注册。
Other brand and product names are trademarks of their respective companies.
P1:certprpg
Last updated: October 16, 2019

SAS® Certified Professional Prep Guide: Advanced Programming Using SAS® 9.4
1. Title Page
2. Copyright
3. Using Sample Data
4. Accessibility Features of the Prep Guide
5. How to Prepare for the Exam
6. Part 1: SQL Processing with SAS
1. Chapter 1: PROC SQL Fundamentals
1. PROC SQL Basics
2. The PROC SQL SELECT Statement
3. The FROM Clause
4. The WHERE Clause
5. The GROUP BY Clause
6. The HAVING Clause
7. The ORDER BY Clause
8. PROC SQL Options
9. Validating Query Syntax
10. Quiz
11. End Notes
2. Chapter 2: Creating and Managing Tables
1. The CREATE TABLE Statement
2. Using the LIKE Clause
3. Using the AS Keyword
4. The INSERT Statement
5. The DESCRIBE TABLE Statement
6. Using Dictionary Tables
7. Chapter Quiz
3. Chapter 3: Joining Tables Using PROC SQL
1. Understanding Joins
2. Generating a Cartesian Product
3. Using Inner Joins
4. Using Natural Joins
5. Using Outer Joins
6. Comparing SQL Joins and DATA Step Match-Merges
7. Quiz
4. Chapter 4: Joining Tables Using Set Operators
1. Understanding Set Operators
2. Using the EXCEPT Set Operator
3. Using the INTERSECT Set Operator
剩余1153页未读,继续阅读
资源评论


view3
- 粉丝: 9
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助


最新资源
- 提货申请单(Excel表格通用模板).xls
- 网络游戏营销模式分析及对策.doc
- 基于蓝墨云班课的职业教育信息化教学改革研究.docx
- 专业技术人员继续教育。物联网技术与应运习题.doc
- 单片机技术报告(篮球计时计分器).doc
- 计算机音乐技术在音乐教学中的应用.docx
- Apache Doris中文手册
- (分)软件技术基础(包含数据结构、软件工程、数据库基础知识和基本内容).doc
- 以项目导向为主的电子商务专业教学改革实践研究.doc
- 基于区块链的供应链金融应用研究.docx
- 2010年软件水平考试网络工程考前冲刺练习题(6).doc
- 深度学习面试宝典(含数学、机器学习、深度学习、计算机视觉、自然语言处理和SLAM等方向)Deep Learning Interview Guide (including mathematics, ma
- 嵌入式操作系统WindowsCE研究分析报告.doc
- 文档聚类与主题发现的新算法探索
- 【SpringBoot开发】Cursor配置指南:环境搭建、插件安装与项目调试全流程详解
- python的sqlserver连接组件,适合3.8版本
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈



安全验证
文档复制为VIP权益,开通VIP直接复制
