Practical SAS Programming and Certification Review

位教师：Stacey Syphus

访问权限由 Coursera Learning Team 提供

15,588 人已注册

7个模块

深入了解一个主题并学习基础知识。

356 条评论

中级等级

需要一些相关经验

灵活的计划

2 周在 10 小时一周

自行安排学习进度

94%

大多数学生喜欢此课程

7个模块

深入了解一个主题并学习基础知识。

356 条评论

中级等级

需要一些相关经验

灵活的计划

2 周在 10 小时一周

自行安排学习进度

94%

大多数学生喜欢此课程

您将获得的技能

您将学习的工具

要了解的详细信息

可分享的证书

添加到您的领英档案

作业

54 项作业

授课语言：英语（English）

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

积累 Data Analysis 领域的专业知识

本课程是 SAS Programmer 专业证书专项课程的一部分

在注册此课程时，您还会同时注册此专业证书。

向行业专家学习新概念
获得对主题或工具的基础理解
通过实践项目培养工作相关技能
通过 SAS 获得可共享的职业证书

该课程共有7个模块

In this course you have the opportunity to use the skills you acquired in the two SAS programming courses to solve realistic problems. This course is also designed to give you a thorough review of SAS programming concepts so you are prepared to take the SAS Certified Specialist: Base Programming Using SAS 9.4 Exam.

In this module you get an overview of this course and set up the data you need for practices and activities.

涵盖的内容

3个视频4篇阅读材料

This module is a review of the first three modules of the Getting Started with SAS Programming course. Lectures demonstrate the concepts you learned, and readings from the SAS Certification Prep Guide reinforce those concepts. The review and programming questions assess your understanding of the material.

涵盖的内容

9个视频3篇阅读材料11个作业

9个视频总计26分钟

Program Structure and Syntax3分钟
Required SAS Column Attributes4分钟
Finding and Resolving Syntax Errors2分钟
Overview1分钟
Directly Accessing Structured Data4分钟
Importing Unstructured Data3分钟
Viewing Table Properties with PROC CONTENTS3分钟
Overview1分钟
Using SAS Procedures to Explore and Validate Data7分钟

3篇阅读材料总计30分钟

SAS® Certification Prep Guide Review: Essentials10分钟
SAS® Certification Prep Guide Review - Access10分钟
SAS® Certification Prep Guide Review - Explore10分钟

11个作业总计140分钟

Programming Question 1.0110分钟
Programming Question 1.0210分钟
Programming Question 1.0310分钟
Programming Question 1.0410分钟
Programming Question 1.0510分钟
Programming Question 1.0610分钟
Programming Question 1.0710分钟
Programming Question 1.0810分钟
Essentials Review Questions20分钟
Accessing Data Review Questions20分钟
Exploring Data Review Questions20分钟

This module reviews the preparing, analyzing and exporting modules of the Getting Started with SAS Programming course. Lectures demonstrate the concepts you learned, and readings from the SAS Certification Prep Guide reinforce those concepts. The review and programming questions assess your understanding of the material.

涵盖的内容

8个视频3篇阅读材料14个作业

8个视频总计31分钟

Overview1分钟
Using the DATA Step to Prepare Data7分钟
Using PROC SQL to Join Tables3分钟
Using PROC FREQ3分钟
Using PROC MEANS7分钟
Overview1分钟
Using PROC EXPORT3分钟
Using the Output Delivery System6分钟

3篇阅读材料总计30分钟

SAS® Certification Prep Guide Review - Prepare10分钟
SAS® Certification Prep Guide Review - Analyze10分钟
SAS® Certification Prep Guide Review - Export10分钟

14个作业总计170分钟

Programming Question 2.0110分钟
Programming Question 2.0210分钟
Programming Question 2.0310分钟
Programming Question 2.0410分钟
Programming Question 2.0510分钟
Programming Question 2.0610分钟
Programming Question 2.0710分钟
Programming Question 2.0810分钟
Programming Question 2.0910分钟
Programming Question 2.1010分钟
Programming Question 2.1110分钟
Preparing Data Review Questions20分钟
Analyzing Data Review Questions20分钟
Exporting Data Review Questions20分钟

This module enables you to apply what you learned in Getting Started with SAS Programming to a real programming problem.

涵盖的内容

6个视频9篇阅读材料1个作业1个讨论话题

6个视频总计35分钟

Case Study Overview5分钟
Accessing Data - Solution3分钟
Exploring Data - Solution6分钟
Preparing Data - Solution8分钟
Analyzing Data - Solution10分钟
Exporting Reports - Solution4分钟

9篇阅读材料总计90分钟

Possible Approaches to Solving this Case Study10分钟
TSA Case Study: Data and Report Requirements10分钟
TSA Case Study: Assignment Guide10分钟
Accessing Data - Hints10分钟
Exploring Data - Hints10分钟
Preparing Data - Hints10分钟
Analyzing Data - Hints10分钟
Exporting Reports - Hints10分钟
Check Your Code10分钟

1个作业总计20分钟

Test your Case Study Code20分钟

1个讨论话题总计10分钟

Your turn - How did you solve this case study?10分钟

This module is a review of the first four modules of the Doing More with SAS Programming course. Lectures demonstrate the concepts you learned about for preparing data, and readings from the SAS Certification Prep Guide reinforce those concepts. The review and programming questions assess your understanding of the material.

涵盖的内容

6个视频4篇阅读材料16个作业

6个视频总计34分钟

Understanding DATA Step Processing7分钟
Directing DATA Step Output3分钟
Summarizing Data7分钟
Using Numeric, Character, and Date Functions8分钟
Using the INTNX and INTCK Functions3分钟
Creating and Using Custom Formats6分钟

4篇阅读材料总计40分钟

SAS® Certification Prep Guide Review - Controlling DATA Step Processing10分钟
SAS® Certification Prep Guide Review - Summarizing Data10分钟
SAS® Certification Prep Guide Review - Manipulating Data with Functions10分钟
SAS® Certification Prep Guide Review - Creating & Using Custom Formats10分钟

16个作业总计210分钟

Programming Question 4.0110分钟
Programming Question 4.0210分钟
Programming Question 4.0310分钟
Programming Question 4.0410分钟
Programming Question 4.0510分钟
Programming Question 4.0610分钟
Programming Question 4.0710分钟
Programming Question 4.0810分钟
Programming Question 4.0910分钟
Programming Question 4.1010分钟
Programming Question 4.1110分钟
Programming Question 4.1210分钟
Controlling DATA Step Processing Review Questions20分钟
Summarizing Data Review Questions20分钟
Manipulating Data with Functions Review Questions20分钟
Creating and Using Custom Formats Review Questions30分钟

This module is a review of the last three modules of the Doing More with SAS Programming course. Lectures demonstrate the concepts you learned about for preparing data, and readings from the SAS Certification Prep Guide reinforce those concepts. The review and programming questions assess your understanding of the material.