課程信息
25,726

第 2 門課程(共 3 門)

100% 在線

立即開始,按照自己的計劃學習。

可靈活調整截止日期

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

中級

完成時間大約為24 小時

建議:15 hours/week...

英語(English)

字幕:英語(English)

第 2 門課程(共 3 門)

100% 在線

立即開始,按照自己的計劃學習。

可靈活調整截止日期

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

中級

完成時間大約為24 小時

建議:15 hours/week...

英語(English)

字幕:英語(English)

教學大綱 - 您將從這門課程中學到什麼

1
完成時間為 1 小時

Course Overview and Data Setup

In this module you get an overview of what you learn in this course and your set up for software and the data you use for activities and practices in the course....
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

In this module, we dig deeper into the DATA step. You learn how the DATA step processes data behind the scenes. Then you use this knowledge to control when and where the DATA step outputs rows to new tables....
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

In this module, you learn new syntax that enables you to alter the default behavior of the DATA step to solve a problem. First you learn to create an accumulating column, or in other words generate a running total. Then you learn to process data in groups, so you can perform an action when each group begins or ends. ...
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

In this module, you learn to use some new functions that enable you to manipulate numeric, date, and character values. In addition, you learn to use functions that change a column from one data type to another....
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

In this module, you learn to create and use custom formats to enhance the way your data is displayed in a table or report....
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分鐘
5
完成時間為 3 小時

Combining Tables

In this module, we take a comprehensive look at combining tables by using the DATA step. You learn to concatenate tables, merge tables, and identify matching and nonmatching rows....
14 個視頻 (總計 28 分鐘), 1 個閱讀材料, 10 個測驗
14 個視頻
Concatenating Tables with Matching Columns1分鐘
Demo: Concatenating Tables3分鐘
Handling Column Attributes45
What is a Merge?1分鐘
Processing a One-to-One Merge2分鐘
Processing a One-To-Many Merge1分鐘
Demo: Merging Tables3分鐘
Merging Tables with Nonmatching Rows2分鐘
Identifying Matches and Nonmatches1分鐘
Demo: Merging Tables with Nonmatching Rows6分鐘
Merging Tables with Matching Column Names1分鐘
Merging Tables without a Common Column1分鐘
DATA Step Merge and PROC SQL Join38
1 個閱讀材料
Syntax Review10分鐘
10 個練習
Activity 5.0110分鐘
Level 1 Practice: Concatenating Like-Structured Tables20分鐘
Level 2 Practice: Concatenating Unlike-Structured Tables20分鐘
Question 5.025分鐘
Activity 5.0310分鐘
Question 5.045分鐘
Activity 5.0510分鐘
Level 1 Practice: Performing a One-to-Many Merge20分鐘
Level 2 Practice: Writing Matches and Nonmatches to Separate Tables20分鐘
Combining Tables30分鐘
6
完成時間為 3 小時

Processing Repetitive Code

In this module, you learn to save time by taking advantage of iterative processing with DO loops. First you learn to create an iterative DO Loop, then you learn to create conditional DO loops....
11 個視頻 (總計 25 分鐘), 1 個閱讀材料, 7 個測驗
11 個視頻
Processing Repetitive Code50
Iterative DO Loops2分鐘
Demo: Executing an Iterative DO Loop2分鐘
Output Inside and Outside the DO Loop2分鐘
Demo: Using Iterative DO Loops5分鐘
Conditional DO Loops1分鐘
Checking the Condition1分鐘
Demo: Using Conditional DO Loops4分鐘
Combining Iterative and Conditional DO Loops1分鐘
Demo: Combining Iterative and Conditional DO Loops3分鐘
1 個閱讀材料
Syntax Review10分鐘
7 個練習
Activity 6.0110分鐘
Level 1 Practice: Using Nested Iterative DO Loops (DATA Step with No SET Statement)20分鐘
Level 2 Practice: Using an Iterative DO Loop (DATA Step with a SET Statement)20分鐘
Activity 6.0210分鐘
Level 1 Practice: Using a Conditional DO Loop20分鐘
Level 2 Practice: Using an Iterative and Conditional DO Loop20分鐘
Processing Repetitive Code30分鐘
7
完成時間為 3 小時

Restructuring Tables

In this module, you learn techniques that can be used to transpose or restructure a table. First you learn to restructure data with the DATA step. Then you learn to restructure data by using the TRANSPOSE procedure....
10 個視頻 (總計 12 分鐘), 1 個閱讀材料, 9 個測驗
10 個視頻
Understanding Table Structure46
Restructuring Data36
Demo: Creating a Narrow Table with the DATA Step3分鐘
Creating a Wide Table with the DATA Step44
The Transpose Procedure24
Transposing Values within Groups48
Demo: Creating a Wide Table with PROC TRANSPOSE4分鐘
Creating a Narrow Table with PROC TRANSPOSE27
Changing Column Names59
1 個閱讀材料
Syntax Review10分鐘
9 個練習
Question 7.015分鐘
Activity 7.0210分鐘
Level 1 Practice: Restructuring a Table Using the DATA Step: Wide to Narrow20分鐘
Level 2 Practice: Restructuring a Table Using the DATA Step: Narrow to Wide20分鐘
Activity 7.0310分鐘
Activity 7.0410分鐘
Level 1 Practice: Restructuring a Table Using PROC TRANSPOSE: Wide to Narrow20分鐘
Level 2 Practice: Restructuring a Table Using PROC TRANSPOSE: Narrow to Wide20分鐘
Restructuring Tables30分鐘
4.8
12 個審閱Chevron Right

熱門審閱

創建者 VVApr 25th 2019

I love the way the course content builds on itself in such a systematic way, and welcome the variety of exercises and practices.

創建者 MMMar 16th 2019

e\n\nx\n\nc\n\ne\n\nl\n\nl\n\ne\n\nn\n\nt\n\nh\n\na\n\nn\n\nd\n\ns\n\no\n\nn\n\ne\n\nx\n\np\n\ne\n\nr\n\nI\n\ne\n\nn\n\nc\n\ne

講師

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® Programming 專項課程

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® Programming

常見問題

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

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

還有其他問題嗎?請訪問 學生幫助中心