About this Course

최근 조회 161,674회

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.

Learner Career Outcomes

21%

이 강좌를 수료한 후 새로운 경력 시작하기

26%

이 강좌를 통해 확실한 경력상 이점 얻기

10%

급여 인상 또는 승진하기

100% 온라인

지금 바로 시작해 나만의 일정에 따라 학습을 진행하세요.

다음 전문 분야의 3개 강좌 중 1번째 강좌:

SAS Programmer

유동적 마감일

일정에 따라 마감일을 재설정합니다.

초급 단계

완료하는 데 약 25시간 필요

권장: 15 hours/week...

영어

자막: 영어

Learner Career Outcomes

21%

이 강좌를 수료한 후 새로운 경력 시작하기

26%

이 강좌를 통해 확실한 경력상 이점 얻기

10%

급여 인상 또는 승진하기

100% 온라인

지금 바로 시작해 나만의 일정에 따라 학습을 진행하세요.

다음 전문 분야의 3개 강좌 중 1번째 강좌:

SAS Programmer

유동적 마감일

일정에 따라 마감일을 재설정합니다.

초급 단계

완료하는 데 약 25시간 필요

권장: 15 hours/week...

영어

자막: 영어

강의 계획 - 이 강좌에서 배울 내용

주

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.

5개 동영상 (총 16분), 4 readings

5개의 동영상

Welcome to the Course!1m

Demo: Programming in SAS7m

Practicing in This Course35

How to Set Up the Course Files in SAS OnDemand for Academics3m

How to Set Up Course Files for SAS University Edition3m

4개의 읽기 자료

Learner Prerequisites10m

Choosing and Setting Up SAS Software for this Course10m

Need Help Setting Up Software?10m

Using Forums and Getting Help10m

완료하는 데 2시간 필요

Essentials

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

7개 동영상 (총 16분), 2 readings, 3 quizzes

7개의 동영상

Overview17

SAS Programming Interfaces56

Demo: Programming with SAS Studio4m

SAS Program Structure2m

SAS Program Syntax55

Demo: Understanding SAS Program Syntax2m

Demo: Finding and Resolving Syntax Errors4m

2개의 읽기 자료

Practice Using SAS Studio20m

Syntax Review10m

3개 연습문제

Activity 1.0110m

Activity 1.0210m

Essentials30m

주

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.

14개 동영상 (총 27분), 1 reading, 9 quizzes

14개의 동영상

Overview33

Types of Data1m

What is a SAS Table?1m

Required Column Attributes for SAS Tables2m

Listing Table and Column Attributes1m

Accessing Data in a Program1m

Using a Library to Read SAS Data3m

Automatic SAS Libraries1m

Demo: Exploring Automatic SAS Libraries3m

Using a Library to Read Other File Types2m

Demo: Using a Library to Read Excel Files3m

Importing Unstructured Data2m

Demo: Importing a Comma-Delimited (CSV) File2m

Importing an Excel File1m

1개의 읽기 자료

Syntax Review10m

9개 연습문제

Question 2.015m

Activity 2.0210m

Activity 2.0310m

Activity 2.04: Create a Library for This Course (Required)10m

Activity 2.0510m

Activity 2.0610m

Level 1 Practice: Importing Excel Data from a Single Worksheet20m

Level 2 Practice: Importing Data from a CSV File20m

Accessing Data30m

주

3

완료하는 데 5시간 필요

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개 동영상 (총 41분), 1 reading, 14 quizzes

16개의 동영상

Overview42

Exploring Data with Procedures1m

Demo: Exploring Data with SAS Procedures6m

Filtering Rows with the WHERE Statement1m

Combining Expressions in a WHERE Statement58

Demo: Filtering Rows with Basic Operators5m

Using Special WHERE Operators1m

Creating and Using Macro Variables2m

Demo: Filtering Rows Using Macro Variables3m

Formatting Data Values in Results1m

Common Formats for Numeric Values1m

Common Formats for Date Values26

Demo: Formatting Data Values in Results3m

Sorting Data1m

Identifying and Removing Duplicates1m

Demo: Identifying and Removing Duplicate Values5m

1개의 읽기 자료

Syntax Review10m

14개 연습문제

Activity 3.0110m

Level 1 Practice: Exploring Data with Procedures20m

Level 2 Practice: Using Procedures to Validate Data20m

Activity 3.0210m

Activity 3.0310m

Activity 3.0410m

Level 1 Practice: Filtering Rows in a Listing Report Using Character Data20m

Level 2 Practice: Using Macro Variables to Subset Data in Procedures20m

Activity 3.0510m

Activity 3.0610m

Activity 3.0710m

Level 1 Practice: Sorting Data and Creating an Output Table20m

Level 2 Practice: Sorting Data to Remove Duplicate Rows20m

Exploring and Validating Data30m

주

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.

13개 동영상 (총 28분), 4 readings, 16 quizzes

13개의 동영상

Overview47

Using the DATA Step to Create a SAS Data Set1m

DATA Step Processing1m

Demo: Working with the DATA Step3m

Demo: Using Expressions to Create New Columns3m

Using Numeric Functions to Create Columns57

Demo: Using Character Functions2m

Demo: Using Date Functions3m

Demo: Conditional Processing with IF-THEN3m

Conditional Processing with IF-THEN/ELSE1m

Creating Character Columns with the LENGTH Statement1m

Processing Multiple Statements with IF-THEN/DO1m

Demo: Processing Multiple Statements with IF-THEN/DO2m

4개의 읽기 자료

Common Summary Functions for Creating Columns5m

Common Character Functions for Creating Columns2m

Common Date Functions for Creating Columns2m

Syntax Review10m

16개 연습문제

Question 4.015m

Question 4.022m

Activity 4.0310m

Level 1 Practice: Creating a SAS Table20m

Level 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table20m

Activity 4.0410m

Activity 4.0510m

Activity 4.0610m

Level 1 Practice: Creating New Columns20m

Level 2 Practice: Creating New Columns with Character and Date Functions20m

Activity 4.0710m

Activity 4.0810m

Activity 4.0910m

Level 1 Practice: Processing Statements with IF-THEN/ELSE20m

Level 2 Practice: Processing Statements Conditionally with DO Groups20m

Preparing Data30m

주

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.

11개 동영상 (총 25분), 2 readings, 11 quizzes

11개의 동영상

Overview46

Using Titles and Footnotes1m

Using Macro Variables and Functions in Titles and Footnotes31

Applying Temporary Labels to Columns1m

Segmenting Reports39

Demo: Enhancing Reports4m

Applying Permanent Labels to Columns20

Demo: Creating Frequency Reports and Graphs7m

Demo: Creating Two-Way Frequency Reports4m

Demo: Creating a Summary Statistics Reports4m

Creating an Output Summary Table22

2개의 읽기 자료

Examples of Procedures that Analyze Data5m

Syntax Review10m

11개 연습문제

Activity 5.0110m

Activity 5.0210m

Activity 5.0310m

Activity 5.0410m

Level 1 Practice: Creating One-Way Frequency Reports20m

Level 2 Practice: Creating Two-Way Frequency Reports20m

Activity 5.0510m

Activity 5.0610m

Level 1 Practice: Producing a Descriptive Statistics Report20m

Level 2 Practice: Creating an Output Table with Custom Columns20m

Analyzing and Reporting on Data30m

주

6

완료하는 데 2시간 필요

Exporting Results

In this module, you learn to export SAS tables and results to Excel, Microsoft Word, and PDF files.

8개 동영상 (총 18분), 3 readings, 6 quizzes

8개의 동영상

Overview28

Exporting Data1m

Demo: Exporting Data to an Excel Workbook3m

Using the SAS Output Delivery System1m

Exporting Results to CSV26

Demo: Exporting Results to Excel5m

Exporting Results to PowerPoint and Microsoft Word30

Demo: Exporting Results to PDF4m

3개의 읽기 자료

Create a Macro Variable (REQUIRED)10m

Activity: Create PowerPoint and RTF Files1m

Syntax Review10m

6개 연습문제

Activity 6.0110m

Activity 6.0210m

Activity 6.0310m

Level 1 Practice: Creating an Excel File Using ODS EXCEL20m

Level 2 Practice: Creating a Document with ODS RTF20m

Exporting Results30m

완료하는 데 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.

10개 동영상 (총 17분), 1 reading, 5 quizzes

10개의 동영상

Overview35

SQL and SAS1m

PROC SQL Syntax1m

Filtering and Sorting Output1m

Demo: Reading and Filtering Data with SQL4m

Creating and Deleting Tables in SQL32

Creating Inner Joins in SQL2m

Demo: Joining Tables with PROC SQL4m

Using Table Aliases26

You've Finished the Course!25

1개의 읽기 자료

Syntax Review10m

5개 연습문제

Activity 7.0110m

Activity 7.0210m

Activity 7.0310m

Activity 7.0410m

Using SQL in SAS30m

강사

Stacey Syphus

Senior Manager

Education

자주 묻는 질문

강의 및 과제를 언제 이용할 수 있게 되나요?
강좌에 등록하면 바로 모든 비디오, 테스트 및 프로그래밍 과제(해당하는 경우)에 접근할 수 있습니다. 상호 첨삭 과제는 이 세션이 시작된 경우에만 제출하고 검토할 수 있습니다. 강좌를 구매하지 않고 살펴보기만 하면 특정 과제에 접근하지 못할 수 있습니다.
이 수료 과정을 구독하면 무엇을 이용할 수 있나요?
강좌를 등록하면 수료 과정의 모든 강좌에 접근할 수 있고 강좌를 완료하면 수료증을 취득할 수 있습니다. 전자 수료증이 성취도 페이지에 추가되며, 해당 페이지에서 수료증을 인쇄하거나 LinkedIn 프로필에 수료증을 추가할 수 있습니다. 강좌 내용만 읽고 살펴보려면 해당 강좌를 무료로 청강할 수 있습니다.
환불 규정은 어떻게 되나요?

궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.

Earn an Ivy League CS Master’s designed for non-CS majors

Easily transfer credits to earn your bachelor’s degree faster

Getting Started with SAS Programming

Learner Career Outcomes

21%

26%

10%

100% 온라인

다음 전문 분야의 3개 강좌 중 1번째 강좌:

유동적 마감일

초급 단계

완료하는 데 약 25시간 필요

영어

Learner Career Outcomes

21%

26%

10%

100% 온라인

다음 전문 분야의 3개 강좌 중 1번째 강좌:

유동적 마감일

초급 단계

완료하는 데 약 25시간 필요

영어

강의 계획 - 이 강좌에서 배울 내용

Course Overview and Data Setup

Essentials

Accessing Data

Exploring and Validating Data

Preparing Data

Analyzing and Reporting on Data

Exporting Results

Using SQL in SAS

Getting Started with SAS Programming의 최상위 리뷰

강사

Stacey Syphus

SAS 정보

SAS Programmer 전문 자격증 정보

자주 묻는 질문