4.8
星
1,865 个评分

Stacey Syphus

57,469 人已注册

提供方

包含在

中

无限制访问 3,000+ 门课程、指导项目、专项课程和专业证书。

了解更多

SAS

课程信息

179,972 次近期查看

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.

学生职业成果

17%

完成这些课程后已开始新的职业生涯

23%

通过此课程获得实实在在的工作福利

13%

加薪或升职

可分享的证书

完成后获得证书

100% 在线

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

可灵活调整截止日期

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

初级

完成时间大约为22 小时

英语（English）

字幕：阿拉伯语（Arabic）, 法语（French）, （欧洲人讲的）葡萄牙语, 意大利语, 越南语, 德语（German）, 俄语（Russian）, 英语（English）, 西班牙语（Spanish）

讲师

授课教师评分

4.84/5 （469 个评分）

Stacey Syphus

学生职业成果

17%

完成这些课程后已开始新的职业生涯

23%

通过此课程获得实实在在的工作福利

13%

加薪或升职

可分享的证书

完成后获得证书

100% 在线

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

可灵活调整截止日期

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

初级

完成时间大约为22 小时

英语（English）

提供方

SAS

Through innovative software and services, SAS empowers and inspires customers around the world to transform data into intelligence. SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.

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

内容评分93%（7,300 个评分）

周

周 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.

完成时间为 1 小时

3 个视频（总计 10 分钟）, 3 个阅读材料

完成时间为 2 小时

Essentials

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

完成时间为 2 小时

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

周

周 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.

完成时间为 3 小时

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

完成时间为 4 小时

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.

完成时间为 4 小时

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

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

Demo: Identifying and Removing Duplicate Values3分钟

1 个阅读材料

Syntax Review10分钟

13 个练习

Activity 3.0110分钟

Level 1 Practice: Exploring Data with Procedures20分钟

Level 2 Practice: Using Procedures to Validate Data20分钟

Activity 3.0210分钟

Activity 3.0310分钟

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

Activity 3.0510分钟

Activity 3.0610分钟

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.

完成时间为 5 小时

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.

完成时间为 4 小时

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

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

Creating an Output Summary Table22

2 个阅读材料

Examples of Procedures that Analyze Data5分钟

Syntax Review10分钟

10 个练习

Activity 5.0110分钟

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.

完成时间为 2 小时

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.

完成时间为 2 小时

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

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

4 个练习

Activity 7.0110分钟

Activity 7.0210分钟

Activity 7.0310分钟

Using SQL in SAS30分钟

审阅

4.8

416 条评论

5 stars
86.77%
4 stars
11.18%
3 stars
1.12%
2 stars
0.16%
1 star
0.74%

来自GETTING STARTED WITH SAS PROGRAMMING的热门评论

由 HH 提供Jul 16, 2020

Provides an amazing foundation in SAS as a programmer/data analyst! It covers a lot of important topics to get you started using SAS in real world. It exceeded my expectations, highly recommend it!

由 VH 提供Jun 29, 2020

This was an excellent course. Meticulously planned for a beginner with no much knowledge on SAS. However basic programming logic or knowledge is highly useful. This course has benefited me a lot.

由 SK 提供May 13, 2020

Simple, Straight to the point, Engages learners with tiny quizzes to help in learning actively. Could have more reading material as optional to dive deeper though. Overall, Great beginner course.

由 BM 提供Feb 20, 2019

This course offers a solid foundation to anyone who is interested in beginning to use SAS. I have found the demos, activites and practices to be fairly easy yet still required me to use my brain.

查看所有评论

常见问题

我什么时候能够访问课程视频和作业？
讲座和作业的访问权限取决于您的注册类型。如果您以旁听模式参加课程，则可以免费查看大多数课程资料。要访问评分作业并获得证书，您需要在旁听期间或之后购买证书体验。如果看不到旁听选项：
课程可能不提供旁听选项。您可以尝试免费试用，也可以申请助学金。
课程可能会改为提供'完整课程，没有证书'。通过此选项，您可以查看所有课程材料、提交所要求的作业，以及获得最终成绩。这也意味着您将无法购买证书体验。
我订阅此证书后会得到什么？
您注册课程后，将有权访问证书中的所有课程，并且会在完成作业后获得证书。您的电子证书将添加到您的成就页中，您可以通过该页打印证书或将其添加到您的领英档案中。如果您只想阅读和查看课程内容，可以免费旁听课程。

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

Getting Started with SAS Programming

课程信息

学生职业成果

17%

23%

13%

讲师

Stacey Syphus

学生职业成果

17%

23%

13%

提供方

SAS

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

周 1

Course Overview and Data Setup

Essentials

周 2

Accessing Data

周 3

Exploring and Validating Data

周 4

Preparing Data

周 5

Analyzing and Reporting on Data

周 6

Exporting Results

Using SQL in SAS

审阅

来自GETTING STARTED WITH SAS PROGRAMMING的热门评论

常见问题

热门在线课程

热门在线专项课程

在线证书

在线学位课程

Coursera

社区

更多

Getting Started with SAS Programming

课程信息

学生职业成果

17%

23%

13%

讲师

Stacey Syphus

学生职业成果

17%

23%

13%

提供方

SAS

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

周 1

Course Overview and Data Setup

Essentials

周 2

Accessing Data

周 3

Exploring and Validating Data

周 4

Preparing Data

周 5

Analyzing and Reporting on Data

周 6

Exporting Results

Using SQL in SAS

审阅

来自GETTING STARTED WITH SAS PROGRAMMING的热门评论

常见问题

Coursera Footer

热门在线课程

热门在线专项课程

在线证书

在线学位课程

Coursera

社区

更多