SAS认证及考试Q&A

一、关于SAS认证和考试		二、关于SAS认证的培训
1、SAS认证的应用行业及职业前景		1、报名流程
2、SAS认证的有效期		2、有没有针对大学师生的培训折扣？
3、五级认证的关系		3、外地学员如何获得培训？
4、SAS全球认证的考试方式		4、SAS俱乐部
5、参加SAS认证考试的时间、地点、如何报名？
6、考试费用
7、答对多少题才能通过考试？
8、我已通过认证考试，什么时候才能收到认证证书？
9、考点/考纲

一、关于SAS认证和考试

1、SAS认证的应用行业及职业前景
SAS全球专业认证是国际上公认的数据挖掘和商业智能领域的权威认证，随着我国IT环境和应用的日渐成熟，以上两个领域将有极大的行业发展空间。获取SAS全球专业认证，为您在数据挖掘、分析方法论领域积累丰富经验奠定良好的基础，帮助您开辟职业发展的新天地。

2、SAS认证的有效期
目前SAS五级认证没有特定有效期，但是时间太久或版本太老的认证证书会有所贬值。

3、五级认证的关系
五级认证为递进式关系，即只有通过上一级考试科目才能参加下一级认证考试。

4、SAS全球认证的考试方式
考试为上机考试，时间2个小时，共70道客观题。

5、参加SAS认证考试的时间、地点、如何报名？
就近选择普尔文考试中心授权考点报名（考点查询请参见www.prometric.com.cn），报名时应携带身份证并交纳考试费用，同授权考点预约考试时间。

6、考试费用：￥1035元

7、答对多少题才能通过考试？
答对65%以上的题目才能通过认证考试。

8、我已通过认证考试，什么时候才能收到认证证书？
通常在一个月以内，您将收到SAS从美国Cary寄来的证书。

9、考点/考纲

SAS Base Programming Exam

Accessing Data

• Use FORMATTED, LIST and COLUMN input to read raw data files
• Use INFILE statement options to control processing when reading raw data files
• Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing @ controls
• Combine SAS data sets using the DATA step

Creating Data Structures

• Create temporary and permanent SAS data sets
• Create and manipulate SAS date values
• Use DATA Step statements to export data to standard and comma delimited raw data files
• Control which observations and variables in a SAS data set are processed and output

Managing Data

• Investigate SAS data libraries using base SAS utility procedures
• Sort observations in a SAS data set
• Conditionally execute SAS statements
• Use assignment statements in the DATA step
• Modify variable attributes using options and statements in the DATA step
• Accumulate sub-totals and totals using DATA step statements
• Use SAS functions to manipulate character data, numeric data, and SAS date values
• Use SAS functions to convert character data to numeric and vice versa
• Process data using DO LOOPS
• Process data using SAS arrays

Generating Reports

• Generate list reports using the PRINT and REPORT procedures
• Generate summary reports and frequency tables using base SAS procedures
• Enhance reports through the use of labels, SAS formats, user-defined formats, titles, footnotes and SAS System reporting options
• Generate HTML reports using ODS statements

Handling Errors

• Identify and resolve programming logic errors
• Recognize and correct syntax errors
• Examine and resolve data errors

SAS Advanced Programming Exam

This exam is currently available in production form. This exam is one of two exams in the SAS Certified Advanced Programmer track. This credential requires the successful completion of the SAS Base Programming or SAS Core Concepts V8 exam and the SAS Advanced Programming exam. The SAS Advanced Programming Exam contains 65 questions, 42 of which must be answered correctly to receive a passing score. Please note: Successful completion of the retired V8 Core Concepts Exam will also be accepted as a prerequisite for the SAS Certified Advanced Programmer track.

Accessing Data Using SQL

• Generate detail reports by working with a single table or joining tables using PROC SQL and the appropriate options
• Generate summary reports by working with a single table or joining tables using PROC SQL and the appropriate options
• Construct subqueries within a PROC SQL step
• Compare solving a problem using the SQL procedure versus using traditional SAS programming techniques
• Access Dictionary Tables using the SQL procedure
• Demonstrate advanced PROC SQL skills by creating and updating tables, updating data values, working with indexes using the macro interface/creating macro variables with SQL, defining integrity constraints, SQL views and SET operators

Macro Processing

• Creating and using user-defined and automatic macro variables within the SAS Macro Language
• Automate programs by defining and calling macros using the SAS Macro Language
• Understand the use of macro functions
• Recognize various system options that are available for macro debugging and displaying values of user-defined and automatic macro variables in the SAS log

Advanced Programming Techniques

• Demonstrate advanced data set processing techniques such as updating master data sets, transposing data, combining/merging data, sampling data using generation data sets, integrity constraints and audit trails
• Reduce the space required to store SAS data sets and numeric variables within SAS data sets by using compression techniques, length statements or DATA step views
• Develop efficient programs by using advanced programming techniques such as permanent formats and array processing
• Use SAS System options and SAS data set options for controlling memory usage
• Control the processing of variables and observations in the DATA step
• Create sorted or indexed data in order to avoid unnecessary sorts, eliminate duplicate data and to provide more efficient data access and retrieval
• Use PROC DATASETS to demonstrate advanced programming skills (e.g. renaming columns, displaying metadata, creating indexes, creating integrity constraints, creating audit trails)

二、关于SAS认证的培训

1、报名流程

2、有没有针对大学师生的培训折扣？
SAS培训部对大学师生提供50%的折扣。

3、外地学员如何获得培训？
鉴于目前SAS培训部仅在北京、上海、广州三地举办SAS公开课，外地学员可通过购买SAS
E-LEARNING和SAS LEARNING EDITION（ASIAN VERSION）来学习和运用SAS。

4、SAS俱乐部
通过参加SAS培训部组织的课程，可申请成为SAS俱乐部的成员。SAS俱乐部成员可享受：

1、参加SAS培训课程和购买SAS出版物可以获得更优惠的折扣；
2、各种SAS技术资料(Legal上允许的)、success story、最新产品/方案信息、技术发展趋势等；
3、SAS国内外专家的免费讲座，CASE STUDY；
4、量身定做的企业培训协议和个人数据挖掘职业发展培训计划以及定期的技术交流。