Is this course really 100% online? Do I need to attend any classes in person?

This course is completely online, so there’s no need to show up to a classroom in person. You can access your lectures, readings and assignments anytime and anywhere via the web or your mobile device.

Can I just enroll in a single course?

Yes! To get started, click the course card that interests you and enroll. You can enroll and complete the course to earn a shareable certificate. When you subscribe to a course that is part of a Certificate, you’re automatically subscribed to the full Certificate. Visit your learner dashboard to track your progress.

SAS Advanced Programmer 专业证书

Grow Your Career with a SAS® Credential. Master the skills required for the SAS® Advanced Programming Professional certification.

位教师：Peter Styliadis

10,473 人已注册

包含在 Coursera Plus 中

了解更多

3 门课程系列

获得职业证书，展示您的专业知识

4.8

（343 条评论）

中级等级

推荐体验

灵活的计划

2 月在 10 小时一周

自行安排学习进度

攻读学位

了解更多

3 门课程系列

获得职业证书，展示您的专业知识

4.8

（343 条评论）

中级等级

推荐体验

灵活的计划

2 月在 10 小时一周

自行安排学习进度

攻读学位

了解更多

您将学到什么

Process data using Structured Query Language in the SAS environment
Use the SAS macro facility to design, write, and debug dynamic macro programs
Use advanced DATA step techniques and procedures to manipulate data

要了解的详细信息

可分享的证书

添加到您的领英档案

行业认证

授课语言：英语（English）

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

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

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

专业认证 - 3门课程系列

When you complete this professional certificate program, you will have experience in SAS programming using SAS 9 and will be able to process data using Structured Query Language in the SAS environment, use the SAS macro facility to design, write, and debug dynamic macro programs, and use advanced DATA step techniques and procedures to manipulate data. These skills prepare you for the SAS Advanced Programming Professional certification exam.

应用的学习项目

Two projects are included as honors lessons in this professional certificate program. Each project will demonstrate your comprehensive knowledge of the learned SAS programming skills. In the first project, you use SQL to analyze to analyze passenger claims at United States airports. In the second project, you use the SAS macro language to automate reporting and analysis of analysis of supplier sales.

Structured Query Language (SQL) using SAS

第 1 门课程26小时

您将学到什么

Course Description

In this course, you learn about Structured Query Language (SQL) and how it can be used in SAS programs to create reports and query your data. “By the end of this course, a learner will be able to…” ● Query and subset data. ● Summarize and present data. ● Combine tables using joins and set operators. ● Create and modify tables and views. ● Create data-driven macro variables using a query. ● Access DBMS data with SAS/ACCESS technology.

您将获得的技能

类别：SQL

类别：SAS (Software)

类别：Data Access

类别：Statistical Programming

类别：Query Languages

类别：Data Integration

类别：Data Manipulation

类别：Database Management

类别：Data Presentation

类别：Data Processing

SAS Macro Language

第 2 门课程20小时

您将学到什么

In this course, you learn advanced techniques within the DATA step and procedures to manipulate data.

您将获得的技能

类别：SAS (Software)

类别：Data Processing

类别：Statistical Programming

类别：Data Validation

类别：Automation

类别：Case Studies

类别：Scripting

类别：Data Manipulation

类别：Program Development

类别：Debugging

Advanced SAS Programming Techniques

第 3 门课程18小时

您将学到什么

In this course, you learn advanced techniques within the DATA step and procedures to manipulate data.

“By the end of this course, a learner will be able to…” ● Use additional functions (LAG, FINDC/FINDW, and COUNT/COUNTC/COUNTW). ● Perform pattern matching using PRX functions. ● Process repetitive code, rotate data, and perform table lookups using arrays. ● Perform table lookups and sort data using hash and hash iterator objects. ● Create numeric templates using the FORMAT procedure. ● Create custom functions using the FCMP procedure.