课程信息

169,478 次近期查看

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.

第 1 门课程（共 3 门）

SAS Programmer

100% 在线

立即开始，按照自己的计划学习。

可灵活调整截止日期

根据您的日程表重置截止日期。

初级

完成时间大约为24 小时

建议：15 hours/week...

英语（English）

字幕：英语（English）

学习Professional Certificate的学生是

Data Analysts
Risk Managers
Biostatisticians

Data Scientists
Business Analysts

第 1 门课程（共 3 门）

SAS Programmer

100% 在线

立即开始，按照自己的计划学习。

可灵活调整截止日期

根据您的日程表重置截止日期。

初级

完成时间大约为24 小时

建议：15 hours/week...

英语（English）

字幕：英语（English）

教学大纲 - 您将从这门课程中学到什么

周

1

完成时间为 1 小时

Course Overview and Data Setup

In this module you learn about the course and you set up the data you need to do the practices in the course.

5 个视频（总计 16 分钟）, 4 个阅读材料

5 个视频

Welcome to the Course!1分钟

Demo: Programming in SAS7分钟

Practicing in This Course35

How to Set Up the Course Files in SAS OnDemand for Academics3分钟

How to Set Up Course Files for SAS University Edition3分钟

4 个阅读材料

Learner Prerequisites10分钟

Choosing and Setting Up SAS Software for this Course10分钟

Need Help Setting Up Software?10分钟

Using Forums and Getting Help10分钟

完成时间为 2 小时

Essentials

In this module you learn how to use SAS programming tools and the fundamentals of SAS program structure and syntax.

7 个视频（总计 16 分钟）, 2 个阅读材料, 3 个测验

7 个视频

Overview17

SAS Programming Interfaces56

Demo: Programming with SAS Studio4分钟

SAS Program Structure2分钟

SAS Program Syntax55

Demo: Understanding SAS Program Syntax2分钟

Demo: Finding and Resolving Syntax Errors4分钟

2 个阅读材料

Practice Using SAS Studio20分钟

Syntax Review10分钟

3 个练习

Activity 1.0110分钟

Activity 1.0210分钟

Essentials30分钟

周

2

完成时间为 3 小时

Accessing Data

In this module, you learn to identify the features of a SAS table, access data through SAS libraries, and import data into SAS.

14 个视频（总计 27 分钟）, 1 个阅读材料, 9 个测验

14 个视频

Overview33

Types of Data1分钟

What is a SAS Table?1分钟

Required Column Attributes for SAS Tables2分钟

Listing Table and Column Attributes1分钟

Accessing Data in a Program1分钟

Using a Library to Read SAS Data3分钟

Automatic SAS Libraries1分钟

Demo: Exploring Automatic SAS Libraries3分钟

Using a Library to Read Other File Types2分钟

Demo: Using a Library to Read Excel Files3分钟

Importing Unstructured Data2分钟

Demo: Importing a Comma-Delimited (CSV) File2分钟

Importing an Excel File1分钟

1 个阅读材料

Syntax Review10分钟

9 个练习

Question 2.015分钟

Activity 2.0210分钟

Activity 2.0310分钟

Activity 2.04: Create a Library for This Course (Required)10分钟

Activity 2.0510分钟

Activity 2.0610分钟

Level 1 Practice: Importing Excel Data from a Single Worksheet20分钟

Level 2 Practice: Importing Data from a CSV File20分钟

Accessing Data30分钟

周

3

完成时间为 5 小时

Exploring and Validating Data

In this module, you learn to use SAS procedures that provide insights about your data. You also learn to subset data so you can focus on particular segments, format data so you can easily understand it, and sort data to identify and resolve duplicate values.

16 个视频（总计 41 分钟）, 1 个阅读材料, 14 个测验

16 个视频

Overview42

Exploring Data with Procedures1分钟

Demo: Exploring Data with SAS Procedures6分钟

Filtering Rows with the WHERE Statement1分钟

Combining Expressions in a WHERE Statement58

Demo: Filtering Rows with Basic Operators5分钟

Using Special WHERE Operators1分钟

Creating and Using Macro Variables2分钟

Demo: Filtering Rows Using Macro Variables3分钟

Formatting Data Values in Results1分钟

Common Formats for Numeric Values1分钟

Common Formats for Date Values26

Demo: Formatting Data Values in Results3分钟

Sorting Data1分钟

Identifying and Removing Duplicates1分钟

Demo: Identifying and Removing Duplicate Values5分钟

1 个阅读材料

Syntax Review10分钟

14 个练习

Activity 3.0110分钟

Level 1 Practice: Exploring Data with Procedures20分钟

Level 2 Practice: Using Procedures to Validate Data20分钟

Activity 3.0210分钟

Activity 3.0310分钟

Activity 3.0410分钟

Level 1 Practice: Filtering Rows in a Listing Report Using Character Data20分钟

Level 2 Practice: Using Macro Variables to Subset Data in Procedures20分钟

Activity 3.0510分钟

Activity 3.0610分钟

Activity 3.0710分钟

Level 1 Practice: Sorting Data and Creating an Output Table20分钟

Level 2 Practice: Sorting Data to Remove Duplicate Rows20分钟

Exploring and Validating Data30分钟

周

4

完成时间为 5 小时

Preparing Data

In this module, you learn how to do some common data manipulations, such as filtering rows and columns, computing new columns, and performing conditional processing.

13 个视频（总计 28 分钟）, 4 个阅读材料, 16 个测验

13 个视频

Overview47

Using the DATA Step to Create a SAS Data Set1分钟

DATA Step Processing1分钟

Demo: Working with the DATA Step3分钟

Demo: Using Expressions to Create New Columns3分钟

Using Numeric Functions to Create Columns57

Demo: Using Character Functions2分钟

Demo: Using Date Functions3分钟

Demo: Conditional Processing with IF-THEN3分钟

Conditional Processing with IF-THEN/ELSE1分钟

Creating Character Columns with the LENGTH Statement1分钟

Processing Multiple Statements with IF-THEN/DO1分钟

Demo: Processing Multiple Statements with IF-THEN/DO2分钟

4 个阅读材料

Common Summary Functions for Creating Columns5分钟

Common Character Functions for Creating Columns2分钟

Common Date Functions for Creating Columns2分钟

Syntax Review10分钟

16 个练习

Question 4.015分钟

Question 4.022分钟

Activity 4.0310分钟

Level 1 Practice: Creating a SAS Table20分钟

Level 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table20分钟

Activity 4.0410分钟

Activity 4.0510分钟

Activity 4.0610分钟

Level 1 Practice: Creating New Columns20分钟

Level 2 Practice: Creating New Columns with Character and Date Functions20分钟

Activity 4.0710分钟

Activity 4.0810分钟

Activity 4.0910分钟

Level 1 Practice: Processing Statements with IF-THEN/ELSE20分钟

Level 2 Practice: Processing Statements Conditionally with DO Groups20分钟

Preparing Data30分钟

周

5

完成时间为 4 小时

Analyzing and Reporting on Data

In this module, we concentrate on summarizing data by using the SAS procedures that we touched on for data exploration. You also learn how to use titles, column labels, footnotes, and macro variables to enhance your reports and make them more meaningful.

11 个视频（总计 25 分钟）, 2 个阅读材料, 11 个测验

11 个视频

Overview46

Using Titles and Footnotes1分钟

Using Macro Variables and Functions in Titles and Footnotes31

Applying Temporary Labels to Columns1分钟

Segmenting Reports39

Demo: Enhancing Reports4分钟

Applying Permanent Labels to Columns20

Demo: Creating Frequency Reports and Graphs7分钟

Demo: Creating Two-Way Frequency Reports4分钟

Demo: Creating a Summary Statistics Reports4分钟

Creating an Output Summary Table22

2 个阅读材料

Examples of Procedures that Analyze Data5分钟

Syntax Review10分钟

11 个练习

Activity 5.0110分钟

Activity 5.0210分钟

Activity 5.0310分钟

Activity 5.0410分钟

Level 1 Practice: Creating One-Way Frequency Reports20分钟

Level 2 Practice: Creating Two-Way Frequency Reports20分钟

Activity 5.0510分钟

Activity 5.0610分钟

Level 1 Practice: Producing a Descriptive Statistics Report20分钟

Level 2 Practice: Creating an Output Table with Custom Columns20分钟

Analyzing and Reporting on Data30分钟

周

6

完成时间为 2 小时

Exporting Results

In this module, you learn to export SAS tables and results to Excel, Microsoft Word, and PDF files.

8 个视频（总计 18 分钟）, 3 个阅读材料, 6 个测验

8 个视频

Overview28

Exporting Data1分钟

Demo: Exporting Data to an Excel Workbook3分钟

Using the SAS Output Delivery System1分钟

Exporting Results to CSV26

Demo: Exporting Results to Excel5分钟

Exporting Results to PowerPoint and Microsoft Word30

Demo: Exporting Results to PDF4分钟

3 个阅读材料

Create a Macro Variable (REQUIRED)10分钟

Activity: Create PowerPoint and RTF Files1分钟

Syntax Review10分钟

6 个练习

Activity 6.0110分钟

Activity 6.0210分钟

Activity 6.0310分钟

Level 1 Practice: Creating an Excel File Using ODS EXCEL20分钟

Level 2 Practice: Creating a Document with ODS RTF20分钟

Exporting Results30分钟

完成时间为 2 小时

Using SQL in SAS

In this module, you learn to use the SQL procedure to read and filter data. You also learn to create and join tables by using SQL.

10 个视频（总计 17 分钟）, 1 个阅读材料, 5 个测验

10 个视频

Overview35

SQL and SAS1分钟

PROC SQL Syntax1分钟

Filtering and Sorting Output1分钟

Demo: Reading and Filtering Data with SQL4分钟

Creating and Deleting Tables in SQL32

Creating Inner Joins in SQL2分钟

Demo: Joining Tables with PROC SQL4分钟

Using Table Aliases26

You've Finished the Course!25

1 个阅读材料

Syntax Review10分钟

5 个练习

Activity 7.0110分钟

Activity 7.0210分钟

Activity 7.0310分钟

Activity 7.0410分钟

Using SQL in SAS30分钟

讲师

Stacey Syphus

Senior Manager

Education

常见问题

我什么时候能够访问课程视频和作业？
注册以便获得证书后，您将有权访问所有视频、测验和编程作业（如果适用）。只有在您的班次开课之后，才可以提交和审阅同学互评作业。如果您选择在不购买的情况下浏览课程，可能无法访问某些作业。
我订阅此证书后会得到什么？
您注册课程后，将有权访问证书中的所有课程，并且会在完成作业后获得证书。您的电子证书将添加到您的成就页中，您可以通过该页打印证书或将其添加到您的领英档案中。如果您只想阅读和查看课程内容，可以免费旁听课程。
退款政策是如何规定的？

还有其他问题吗？请访问学生帮助中心。

Getting Started with SAS Programming

第 1 门课程（共 3 门）

100% 在线

可灵活调整截止日期

初级

完成时间大约为24 小时

英语（English）

第 1 门课程（共 3 门）

100% 在线

可灵活调整截止日期

初级

完成时间大约为24 小时

英语（English）

教学大纲 - 您将从这门课程中学到什么

Course Overview and Data Setup

Essentials

Accessing Data

Exploring and Validating Data

Preparing Data

Analyzing and Reporting on Data

Exporting Results

Using SQL in SAS

25%

31%

12%

来自Getting Started with SAS Programming的热门评论

讲师

Stacey Syphus

关于 SAS

关于 SAS Programmer 专业证书

常见问题