SAS程序员专业证书

你将学到什么

课程概况

When you complete the SAS® Base Programming courses, you will have demonstrated skills in manipulating and transforming data,
combining SAS data sets, creating basic detail and summary reports using SAS
procedures and identifying and correcting data, syntax and programming logic
errors. These skills prepare you for the SAS® Base Programmer certification exam.

包含课程

课程1
Getting Started with SAS Programming

This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. It is a prerequisite to many other SAS courses.By the end of this course, you will know how to use SAS Studio to write and submit SAS programs that access SAS, Microsoft Excel, and text data. You will know how to explore and validate data, prepare data by subsetting rows and computing new columns, analyze and report on data, export data and results to other formats, use SQL in SAS to query and join tables.

Prerequisites:
Learners should have experience using computer software. Specifically, you should be able to understand file structures and system commands on your operating systems and access data files on your operating systems. No prior SAS experience is needed.

课程2
Doing More with SAS Programming

This course is for business analysts and SAS programmers who want to learn data manipulation techniques using the SAS DATA step and procedures to access, transform, and summarize data. The course builds on the concepts that are presented in the Getting Started with SAS Programming course and is not recommended for beginning SAS software users.In this course you learn how to understand and control DATA step processing, create an accumulating column and process data in groups, manipulate data with functions, convert column type, create custom formats, concatenate and merge tables, process repetitive code, and restructure tables. This course addresses Base SAS software.

Before attending this course, you should be able to write DATA step code to access data, subset rows and columns, compute new columns, and process data conditionally. You should also be able to sort tables using the SORT procedure and
apply SAS formats.

课程3
Practical SAS Programming and Certification Review

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 the last course of this specialization, you complete projects that demonstrate your knowledge of SAS programming. In the
first project, you write programs for each stage of the SAS programming
process to analyze passenger claims at United States airports. In the second
project, you use your knowledge of the data preparation stage to write
programs that restructure world tourism data.

预备知识

不需要有编程或SAS经验。