課程信息

117,141 次近期查看

學生職業成果

33%

通過此課程獲得實實在在的工作福利

50%

加薪或升職
可分享的證書
完成後獲得證書
100% 在線
立即開始,按照自己的計劃學習。
第 2 門課程(共 3 門)
可靈活調整截止日期
根據您的日程表重置截止日期。
中級
完成時間大約為24 小時
英語(English)
字幕:英語(English)

學生職業成果

33%

通過此課程獲得實實在在的工作福利

50%

加薪或升職
可分享的證書
完成後獲得證書
100% 在線
立即開始,按照自己的計劃學習。
第 2 門課程(共 3 門)
可靈活調整截止日期
根據您的日程表重置截止日期。
中級
完成時間大約為24 小時
英語(English)
字幕:英語(English)

講師

提供方

SAS 徽標

SAS

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

內容評分Thumbs Up97%(1,633 個評分)Info
1

1

完成時間為 1 小時

Course Overview and Data Setup

完成時間為 1 小時
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

完成時間為 3 小時
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

2

完成時間為 3 小時

Summarizing Data

完成時間為 3 小時
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

3

完成時間為 5 小時

Manipulating Data with Functions

完成時間為 5 小時
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

4

完成時間為 3 小時

Creating and Using Custom Formats

完成時間為 3 小時
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分鐘

審閱

來自DOING MORE WITH SAS PROGRAMMING的熱門評論

查看所有評論

關於 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 Programming Specialist certification exam....
SAS Programmer

常見問題

  • Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

    • The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.

    • The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

  • When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

  • If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.

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