课程信息
59,555 次近期查看

第 2 门课程(共 3 门)

100% 在线

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

可灵活调整截止日期

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

中级

完成时间大约为25 小时

建议:17 hours/week...

英语(English)

字幕:英语(English)

第 2 门课程(共 3 门)

100% 在线

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

可灵活调整截止日期

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

中级

完成时间大约为25 小时

建议:17 hours/week...

英语(English)

字幕:英语(English)

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

1
完成时间为 1 小时

Course Overview and Data Setup

2 个视频 (总计 1 分钟), 4 个阅读材料
2 个视频
Practicing in This Course35
4 个阅读材料
Learner Prerequisites10分钟
Choosing and Setting Up SAS Software for this Course10分钟
Follow These Instructions to Set Up Data for This Course (REQUIRED)30分钟
Using Forums and Getting Help10分钟
完成时间为 3 小时

Controlling DATA Step Processing

14 个视频 (总计 24 分钟), 1 个阅读材料, 9 个测验
14 个视频
DATA Step Review30
DATA Step Processing55
DATA Step Processing: Compilation3分钟
DATA Step Processing: Execution1分钟
Demo: DATA Step Processing in Action6分钟
Viewing Execution in the Log1分钟
Controlling DATA Step Processing1分钟
Implicit and Explicit Output1分钟
Sending Output to Multiple Tables26
Demo: Directing Row Output3分钟
Controlling Column Output30
Demo: Directing Column Output3分钟
Columns in the PDV36
1 个阅读材料
Syntax Review10分钟
9 个练习
Activity 1.0110分钟
Activity 1.0210分钟
Practice: Using PUTLOG Statements to Examine Execution Steps20分钟
Activity 1.0310分钟
Activity 1.0410分钟
Question 1.055分钟
Level 1 Practice: Conditionally Creating Multiple Output Tables20分钟
Level 2 Practice: Conditionally Creating Columns and Output Tables20分钟
Controlling DATA Step Processing30分钟
2
完成时间为 3 小时

Summarizing Data

10 个视频 (总计 19 分钟), 1 个阅读材料, 11 个测验
10 个视频
Demo: Creating an Accumulating Column3分钟
Retaining Values in the PDV1分钟
Using the Sum Statement58
Answering Questions about Groups42
Processing Sorted Data in Groups1分钟
Demo: Identifying the First and Last Row in Each Group4分钟
Subsetting Rows in the Execution Phase2分钟
Demo: Creating an Accumulating Column within Groups2分钟
Using Multiple BY Columns1分钟
1 个阅读材料
Syntax Review10分钟
11 个练习
Activity 2.0110分钟
Question 2.025分钟
Level 1 Practice: Producing a Running Total20分钟
Level 2 Practice: Producing Multiple Totals20分钟
Activity 2.0310分钟
Activity 2.0410分钟
Activity 2.0510分钟
Question 2.065分钟
Level 1 Practice: Generating an Accumulating Column within Groups20分钟
Level 2 Practice: Generating an Accumulating Column within Multiple Groups20分钟
Summarizing Data30分钟
3
完成时间为 5 小时

Manipulating Data with Functions

24 个视频 (总计 40 分钟), 5 个阅读材料, 18 个测验
24 个视频
Review of Functions44
Specifying Columns Lists1分钟
Using a CALL Routine to Modify Data1分钟
Using Numeric Functions1分钟
Demo: Using Numeric Functions2分钟
SAS Date, Datetime, and Time Values53
Extracting Data from a Datetime Value30
Calculating Date Intervals2分钟
Shifting Date Values50
Demo: Shifting Date Values Based on an Interval3分钟
Useful Character Functions53
Extracting Words from a String58
Demo: Using Character Functions to Extract Words from a String3分钟
Searching for Character Strings51
Replacing Character Strings27
Handling Column Type35
Converting Column Type1分钟
Converting Character Values to Numeric Values1分钟
Using a Generic Informat to Read Dates1分钟
Converting the Type of an Existing Column1分钟
Converting Numeric Values to Character Values1分钟
Demo: Using the INPUT Function to Convert Column Types7分钟
Demo: Using the PUT Function to Convert Column Types3分钟
5 个阅读材料
Using Numeric Functions to Change Precision10分钟
Removing Characters from a String10分钟
Identifying Character Positions10分钟
Building Character Strings10分钟
Syntax Review10分钟
18 个练习
Activity 3.0110分钟
Activity 3.0210分钟
Activity 3.0310分钟
Activity 3.0410分钟
Question 3.055分钟
Level 1 Practice: Using the LARGEST and ROUND Functions20分钟
Level 2 Practice: Working with Date/Time Values20分钟
Activity 3.0610分钟
Activity 3.0710分钟
Activity 3.0810分钟
Activity 3.0910分钟
Level 1 Practice: Using the SCAN and PROPCASE Functions20分钟
Level 2 Practice: Searching for Character Strings20分钟
Activity 3.1010分钟
Activity 3.1110分钟
Question 3.125分钟
Activity 3.1310分钟
Manipulating Data with Functions30分钟
4
完成时间为 3 小时

Creating and Using Custom Formats

8 个视频 (总计 16 分钟), 1 个阅读材料, 10 个测验
8 个视频
Formatting Data Values29
Creating and Applying a Custom Format2分钟
Using Ranges1分钟
Demo: Creating and Using Custom Formats3分钟
Reading a Table of Values for a Format2分钟
Demo: Creating Custom Formats from Tables4分钟
Storing Custom Formats1分钟
1 个阅读材料
Syntax Review10分钟
10 个练习
Activity 4.0110分钟
Activity 4.0210分钟
Activity 4.0310分钟
Level 1 Practice: Creating Custom Formats Based on Single Values20分钟
Level 2 Practice: Creating Custom Formats Based on a Range of Values20分钟
Activity 4.0410分钟
Activity 4.0510分钟
Level 1 Practice: Creating a Custom Format from a Table20分钟
Level 2 Practice: Using Conditional Processing to Create a Format from a Table20分钟
Creating and Using Custom Formats30分钟
4.8
30 个审阅Chevron Right

33%

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

50%

加薪或升职

来自Doing More with SAS Programming的热门评论

创建者 RSAug 15th 2019

This course provided me with the know how needed to write SAS programs. I would definitely recommend this course for folks looking to get an insight on writing or understanding SAS codes.

创建者 HRJul 11th 2019

Great second part of the 3 part SAS course. TIP: Print the syntax notes at the end of each week. They will help you take notes and keep track of what you are learning.

讲师

Avatar

Stacey Syphus

Senior Manager
Education

关于 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....

关于 SAS Programmer 专业证书

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....
SAS Programmer

常见问题

  • 注册以便获得证书后,您将有权访问所有视频、测验和编程作业(如果适用)。只有在您的班次开课之后,才可以提交和审阅同学互评作业。如果您选择在不购买的情况下浏览课程,可能无法访问某些作业。

  • 您注册课程后,将有权访问证书中的所有课程,并且会在完成作业后获得证书。您的电子证书将添加到您的成就页中,您可以通过该页打印证书或将其添加到您的领英档案中。如果您只想阅读和查看课程内容,可以免费旁听课程。

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