關於此課程：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 週
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 個視頻, 4 個閱讀材料
- 視頻: Demo: Programming in SAS
- Reading: Learner Prerequisites
- Discussion Prompt: Let us know!
- 視頻: Practicing in This Course
- Reading: Choosing and Setting Up SAS Software for this Course
- Reading: Need Help Setting Up Software?
- 視頻: How to Set Up the Course Files in SAS OnDemand for Academics
- 視頻: How to Set Up Course Files for SAS University Edition
- Reading: Using Forums and Getting Help
Essentials
In this module you learn how to use SAS programming tools and the fundamentals of SAS program structure and syntax.
7 個視頻, 2 個閱讀材料, 2 個練習測驗
- 視頻: SAS Programming Interfaces
- 視頻: Demo: Programming with SAS Studio
- Reading: Practice Using SAS Studio
- 視頻: SAS Program Structure
- Practice Quiz: Activity
- 視頻: SAS Program Syntax
- 視頻: Demo: Understanding SAS Program Syntax
- 視頻: Demo: Finding and Resolving Syntax Errors
- Practice Quiz: Activity
- Discussion Prompt: Are you new to programming?
- Reading: Syntax Review
已評分: Essentials
第 2 週
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 個視頻, 1 個閱讀材料, 8 個練習測驗
- 視頻: Types of Data
- 視頻: What is a SAS Table?
- 視頻: Required Column Attributes for SAS Tables
- Practice Quiz: Question
- Practice Quiz: Activity
- 視頻: Listing Table and Column Attributes
- Practice Quiz: Activity
- 視頻: Accessing Data in a Program
- 視頻: Using a Library to Read SAS Data
- Practice Quiz: Activity: Create a Library for This Course (Required)
- 視頻: Automatic SAS Libraries
- 視頻: Demo: Exploring Automatic SAS Libraries
- 視頻: Using a Library to Read Other File Types
- 視頻: Demo: Using a Library to Read Excel Files
- Practice Quiz: Activity
- Discussion Prompt: Do you understand SAS libraries?
- 視頻: Importing Unstructured Data
- 視頻: Demo: Importing a Comma-Delimited (CSV) File
- Practice Quiz: Activity
- 視頻: Importing an Excel File
- Discussion Prompt: What type of data do you have?
- Practice Quiz: Level 1 Practice: Importing Excel Data from a Single Worksheet
- Practice Quiz: Level 2 Practice: Importing Data from a CSV File
- Reading: Syntax Review
已評分: Accessing Data
第 3 週
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 個視頻, 1 個閱讀材料, 13 個練習測驗
- 視頻: Exploring Data with Procedures
- Practice Quiz: Activity: Using SAS Documentation
- 視頻: Demo: Exploring Data with SAS Procedures
- Practice Quiz: Level 1 Practice: Exploring Data with Procedures
- Practice Quiz: Level 2 Practice: Using Procedures to Validate Data
- 視頻: Filtering Rows with the WHERE Statement
- 視頻: Combining Expressions in a WHERE Statement
- 視頻: Demo: Filtering Rows with Basic Operators
- Practice Quiz: Activity
- 視頻: Using Special WHERE Operators
- Practice Quiz: Activity
- 視頻: Creating and Using Macro Variables
- 視頻: Demo: Filtering Rows Using Macro Variables
- Practice Quiz: Activity
- Practice Quiz: Level 1 Practice: Filtering Rows in a Listing Report Using Character Data
- Practice Quiz: Level 2 Practice: Using Macro Variables to Subset Data in Procedures
- 視頻: Formatting Data Values in Results
- 視頻: Common Formats for Numeric Values
- Practice Quiz: Activity
- 視頻: Common Formats for Date Values
- 視頻: Demo: Formatting Data Values in Results
- Practice Quiz: Activity
- 視頻: Sorting Data
- Practice Quiz: Activity
- 視頻: Identifying and Removing Duplicates
- 視頻: Demo: Identifying and Removing Duplicate Values
- Practice Quiz: Level 1 Practice: Sorting Data and Creating an Output Table
- Practice Quiz: Level 2 Practice: Sorting Data to Remove Duplicate Rows
- Discussion Prompt: What you learned in this module
- Reading: Syntax Review
已評分: Exploring and Validating Data
第 4 週
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 個視頻, 4 個閱讀材料, 15 個練習測驗
- 視頻: Using the DATA Step to Create a SAS Data Set
- Practice Quiz: Question
- 視頻: DATA Step Processing
- Practice Quiz: Question
- 視頻: Demo: Working with the DATA Step
- Practice Quiz: Activity
- Practice Quiz: Level 1 Practice: Creating a SAS Table
- Practice Quiz: Level 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table
- 視頻: Demo: Using Expressions to Create New Columns
- Practice Quiz: Activity
- 視頻: Using Numeric Functions to Create Columns
- Reading: Common Summary Functions for Creating Columns
- Practice Quiz: Activity
- Reading: Common Character Functions for Creating Columns
- 視頻: Demo: Using Character Functions
- Practice Quiz: Activity
- Reading: Common Date Functions for Creating Columns
- 視頻: Demo: Using Date Functions
- Discussion Prompt: Using Functions
- Practice Quiz: Level 1 Practice: Creating New Columns
- Practice Quiz: Level 2 Practice: Creating New Columns with Character and Date Functions
- 視頻: Demo: Conditional Processing with IF-THEN
- 視頻: Conditional Processing with IF-THEN/ELSE
- Practice Quiz: Activity
- 視頻: Creating Character Columns with the LENGTH Statement
- Practice Quiz: Activity
- 視頻: Processing Multiple Statements with IF-THEN/DO
- Practice Quiz: Activity
- 視頻: Demo: Processing Multiple Statements with IF-THEN/DO
- Practice Quiz: Level 1 Practice: Processing Statements with IF-THEN/ELSE
- Practice Quiz: Level 2 Practice: Processing Statements Conditionally with DO Groups
- Discussion Prompt: Check your Understanding
- Reading: Syntax Review
已評分: Preparing Data
第 5 週
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 個視頻, 2 個閱讀材料, 10 個練習測驗
- 視頻: Using Titles and Footnotes
- Practice Quiz: Activity
- 視頻: Using Macro Variables and Functions in Titles and Footnotes
- Practice Quiz: Activity
- 視頻: Applying Temporary Labels to Columns
- 視頻: Segmenting Reports
- 視頻: Demo: Enhancing Reports
- 視頻: Applying Permanent Labels to Columns
- Practice Quiz: Activity
- 視頻: Demo: Creating Frequency Reports and Graphs
- Practice Quiz: Activity
- 視頻: Demo: Creating Two-Way Frequency Reports
- Practice Quiz: Level 1 Practice: Creating One-Way Frequency Reports
- Practice Quiz: Level 2 Practice: Creating Two-Way Frequency Reports
- 視頻: Demo: Creating a Summary Statistics Reports
- Practice Quiz: Activity
- 視頻: Creating an Output Summary Table
- Practice Quiz: Activity
- Practice Quiz: Level 1 Practice: Producing a Descriptive Statistics Report
- Practice Quiz: Level 2 Practice: Creating an Output Table with Custom Columns
- Reading: Examples of Procedures that Analyze Data
- Discussion Prompt: What analyses will you use?
- Reading: Syntax Review
已評分: Analyzing and Reporting on Data
第 6 週
Exporting Results
In this module, you learn to export SAS tables and results to Excel, Microsoft Word, and PDF files.
8 個視頻, 3 個閱讀材料, 5 個練習測驗
- 視頻: Exporting Data
- Reading: Create a Macro Variable (REQUIRED)
- Practice Quiz: Activity
- 視頻: Demo: Exporting Data to an Excel Workbook
- Practice Quiz: Activity
- 視頻: Using the SAS Output Delivery System
- 視頻: Exporting Results to CSV
- 視頻: Demo: Exporting Results to Excel
- Practice Quiz: Activity
- 視頻: Exporting Results to PowerPoint and Microsoft Word
- Reading: Activity: Create PowerPoint and RTF Files
- 視頻: Demo: Exporting Results to PDF
- Practice Quiz: Level 1 Practice: Creating an Excel File Using ODS EXCEL
- Practice Quiz: Level 2 Practice: Creating a Document with ODS RTF
- Discussion Prompt: Exporting Data and Results
- Reading: Syntax Review
已評分: Exporting Results
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 個視頻, 1 個閱讀材料, 4 個練習測驗
- Discussion Prompt: Do you have SQL experience?
- 視頻: SQL and SAS
- 視頻: PROC SQL Syntax
- Practice Quiz: Activity
- 視頻: Filtering and Sorting Output
- 視頻: Demo: Reading and Filtering Data with SQL
- Practice Quiz: Activity
- 視頻: Creating and Deleting Tables in SQL
- Practice Quiz: Activity
- 視頻: Creating Inner Joins in SQL
- 視頻: Demo: Joining Tables with PROC SQL
- 視頻: Using Table Aliases
- Practice Quiz: Activity
- Reading: Syntax Review
- 視頻: You've Finished the Course!
- Discussion Prompt: Let Us Know!
已評分: Using SQL in SAS
常見問題解答
運作方式
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from Your Peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
製作方
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.
價格
| 購買課程 | |
|---|---|
| 訪問課程材料 | 可用 |
| 訪問評分的材料 | 可用 |
| 收到最終成績 | 可用 |
| 獲得可共享的課程證書 | 可用 |
評分和審閱
This is a great and fun course, especially for someone who wants to learn SAS programming. By completing this course, I feel that I have a solid basic foundation in SAS programming. In my opinion, the course is easy-to-follow, and presents the key materials in appropriate chunks.
A great course to start learning SAS Programming, great examples and practices trough the course.