Practical SAS Programming and Certification Review

通过 Coursera Plus 提高技能，仅需 239 美元/年（原价 399 美元）。立即节省

Practical SAS Programming and Certification Review

位教师：Stacey Syphus

15,586 人已注册

包含在中

了解更多

7个模块

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

356 条评论

中级等级

需要一些相关经验

灵活的计划

2 周在 10 小时一周

自行安排学习进度

94%

大多数学生喜欢此课程

7个模块

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

356 条评论

中级等级

需要一些相关经验

灵活的计划

2 周在 10 小时一周

自行安排学习进度

94%

大多数学生喜欢此课程

您将获得的技能

您将学习的工具

SAS (Software)

要了解的详细信息

可分享的证书

添加到您的领英档案

作业

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分钟

Essentials Review Questions20分钟
Accessing Data Review Questions20分钟
Exploring Data Review Questions20分钟
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分钟

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分钟

Preparing Data Review Questions20分钟
Analyzing Data Review Questions20分钟
Exporting Data Review Questions20分钟
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分钟

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分钟

Controlling DATA Step Processing Review Questions20分钟
Summarizing Data Review Questions20分钟
Manipulating Data with Functions Review Questions20分钟
Creating and Using Custom Formats Review Questions30分钟
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分钟

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.

涵盖的内容

6个视频2篇阅读材料11个作业

6个视频总计26分钟

Concatenating Tables4分钟
Merging Tables5分钟
Using Iterative and Conditional DO Loops5分钟
Using Nested DO Loops4分钟
Using the DATA Step to Restructure Tables5分钟
Using PROC TRANSPOSE to Restructure Tables3分钟

2篇阅读材料总计20分钟

SAS® Certification Prep Guide Review - Combining Tables10分钟
SAS® Certification Prep Guide Review - Processing Repetitive Code10分钟

11个作业总计160分钟

Combining Tables Review Questions20分钟
Processing Repetitive Code Review Questions30分钟
Restructuring Tables Review Questions30分钟
Programming Question 5.0110分钟
Programming Question 5.0210分钟
Programming Question 5.0310分钟
Programming Question 5.0410分钟
Programming Question 5.0510分钟
Programming Question 5.0610分钟
Programming Question 5.0710分钟
Programming Question 5.0810分钟

涵盖的内容

7个视频8篇阅读材料1个作业1个讨论话题

7个视频总计38分钟

Case Study Overview: Preparing World Tourism Data6分钟
View the Case Study Data1分钟
Create the Cleaned_Tourism Table, Part 16分钟
Create the Cleaned_Tourism Table, Part 26分钟
Create the Cleaned_Tourism Table, Part 310分钟
Create the Final_Tourism Table6分钟
Create the NoCountryFound Table3分钟

8篇阅读材料总计80分钟

Possible Approaches to Solving this Case Study10分钟
Tourism Case Study Requirements10分钟
Tourism Case Study - Assignment Guide10分钟
Create the Cleaned_Tourism Table, Part 1 - Hints10分钟
Create the Cleaned_Tourism Table, Part 2 - Hints10分钟
Create the Cleaned_Tourism Table, Part 3 - Hints10分钟
Create the Final_Tourism Table - Hints10分钟
Create the NoCountryFound Table - Hints10分钟

1个作业总计15分钟

Test Your Case Study Output Table15分钟

1个讨论话题总计10分钟

Your Turn - What would you do next to this data?10分钟

获得职业证书

将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。

位教师

授课教师评分

(49个评价)

Stacey Syphus

SAS

8 门课程129,086 名学生

提供方

SAS

从 Data Analysis 浏览更多内容

状态：免费试用
SAS
Practicing for the SAS Programming Certification Exam
课程
状态：免费试用
SAS
Preparing for the SAS Programming Certification Exam
课程
状态：免费试用
SAS
SAS Programmer
专业证书
状态：免费试用
SAS
SAS Advanced Programmer
专业证书

人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

自 2018开始学习的学生

''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'

Jennifer J.

自 2020开始学习的学生

''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'

Larry W.

自 2021开始学习的学生

''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'

Chaitanya A.

''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'

学生评论

5 stars
88.76%
4 stars
9.55%
3 stars
1.12%
2 stars
0.56%
1 star
0%

显示 3/356 个

已于 May 24, 2020审阅

One of the best courses I've taken on Coursera, I learned exactly what I've expected.

已于 Dec 22, 2019审阅

Its a very hands own course, providing all the materials and ways for preparing for the actual certification

已于 Sep 12, 2019审阅

Very good course. Taught how to apply concepts to real world problems. Excellent for certificate exam preparation.

查看更多评论

通过 Coursera Plus 开启新生涯

无限制访问 10,000+ 世界一流的课程、实践项目和就业就绪证书课程 - 所有这些都包含在您的订阅中

了解更多

通过在线学位推动您的职业生涯

获取世界一流大学的学位 - 100% 在线

探索学位

加入超过 3400 家选择 Coursera for Business 的全球公司

提升员工的技能，使其在数字经济中脱颖而出

了解更多

常见问题

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.