《sas certification prepguide advanced advanced prep guide 3rd》由会员分享,可在线阅读,更多相关《sas certification prepguide advanced advanced prep guide 3rd(1835页珍藏版)》请在金锄头文库上搜索。
1、 2 The correct bibliographic citation for this manual is as follows: SAS Institute Inc. 2011. SAS Certification Prep Guide: Advanced Programming for SAS9, Third Edition. Cary, NC: SAS Institute Inc. SAS Certification Prep Guide: Advanced Programming for SAS9, Third Edition. Copyright 2011, SAS Insti
2、tute Inc., Cary, NC, USA ISBN 978-1-60764-925-0 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 othe
3、rwise, 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. U.S. Government Restricted Rights Notice: Use, duplication, o
4、r disclosure of this software and related documentation by the U.S. government is subject to the Agreement with SAS Institute and the restrictions set forth in FAR 52.227-19, Commercial Computer Software-Restricted Rights (June 1987). SAS Institute Inc., SAS Campus Drive, Cary, North Carolina 27513.
5、 1st printing, July 2011 SAS Publishing provides a complete selection of books and electronic products to help customers use SAS software to its fullest potential. For more information about our e-books, e-learning products, CDs, and hard-copy books, visit the SAS Publishing Web site at or call 1-8
6、00-727-3228. 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 registered trademarks or trademarks of their respective companies. 3
7、SAS Certification Prep Guide Advanced Programming for SAS9, Third Edition SAS Certification Prep Guide Advanced Programming for SAS9, Third Edition . 3 About This Book . 4 Audience . 4 Syntax Conventions . 6 Part 1 SQL Processing with SAS . 7 Chapter 1 Performing Queries Using PROC SQL . 7 Chapter 2
8、 Performing Advanced Queries Using PROC SQL . 30 Chapter 3 Combining Tables Horizontally Using PROC SQL . 85 Chapter 4 Combining Tables Vertically Using PROC SQL . 130 Chapter 5 Creating and Managing Tables Using PROC SQL . 171 Chapter 6 Creating and Managing Indexes Using PROC SQL . 233 Chapter 7 C
9、reating and Managing Views Using PROC SQL . 254 Chapter 8 Managing Processing Using PROC SQL . 272 Part 2 SAS Macro Language . 295 Chapter 9 Introducing Macro Variables . 296 Chapter 10 Processing Macro Variables at Execution Time . 334 Chapter 11 Creating and Using Macro Programs . 380 Chapter 12 Storing Macro Programs . 432 Part 3 Advanced SAS Programming Techniques . 457 Chapter 13 Creating Samples and Indexes . 457 Chapter 14 Combining Data Vertically . 488 Chapter 15 Combining Data Horizonta