This course is for business analysts and SAS programmers who want to learn data manipulation techniques using the SAS DATA step and procedures to access, transform, and summarize data. The course builds on the concepts that are presented in the Getting Started with SAS Programming course and is not recommended for beginning SAS software users.
In this course you learn how to understand and control DATA step processing, create an accumulating column and process data in groups, manipulate data with functions, convert column type, create custom formats, concatenate and merge tables, process repetitive code, and restructure tables. This course addresses Base SAS software.
Before attending this course, you should be able to write DATA step code to access data, subset rows and columns, compute new columns, and process data conditionally. You should also be able to sort tables using the SORT procedure and
apply SAS formats.
제공자:
1,638명이 이미 등록했습니다!
강의 계획 - 이 강좌에서 배울 내용
주
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 videos (Total 1 min), 4 readings
4개의 읽기 자료
Learner Prerequisites10m
Choosing and Setting Up SAS Software for this Course10m
Follow These Instructions to Set Up Data for This Course (REQUIRED)30m
Using Forums and Getting Help10m
완료하는 데 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 videos (Total 24 min), 1 reading, 9 quizzes
14개의 동영상
Overview15
DATA Step Review30
DATA Step Processing55
DATA Step Processing: Compilation3m
DATA Step Processing: Execution1m
Demo: DATA Step Processing in Action6m
Viewing Execution in the Log1m
Controlling DATA Step Processing1m
Implicit and Explicit Output1m
Sending Output to Multiple Tables26
Demo: Directing Row Output3m
Controlling Column Output30
Demo: Directing Column Output3m
Columns in the PDV36
1개의 읽기 자료
Syntax Review10m
9개 연습문제
Activity 1.0110m
Activity 1.0210m
Practice: Using PUTLOG Statements to Examine Execution Steps20m
Activity 1.0310m
Activity 1.0410m
Question 1.055m
Level 1 Practice: Conditionally Creating Multiple Output Tables20m
Level 2 Practice: Conditionally Creating Columns and Output Tables20m
Controlling DATA Step Processing30m
주
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 videos (Total 19 min), 1 reading, 11 quizzes
10개의 동영상
Overview20
Demo: Creating an Accumulating Column3m
Retaining Values in the PDV1m
Using the Sum Statement58
Answering Questions about Groups42
Processing Sorted Data in Groups1m
Demo: Identifying the First and Last Row in Each Group4m
Subsetting Rows in the Execution Phase2m
Demo: Creating an Accumulating Column within Groups2m
Using Multiple BY Columns1m
1개의 읽기 자료
Syntax Review10m
11개 연습문제
Activity 2.0110m
Question 2.025m
Level 1 Practice: Producing a Running Total20m
Level 2 Practice: Producing Multiple Totals20m
Activity 2.0310m
Activity 2.0410m
Activity 2.0510m
Question 2.065m
Level 1 Practice: Generating an Accumulating Column within Groups20m
Level 2 Practice: Generating an Accumulating Column within Multiple Groups20m
Summarizing Data30m
주
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 videos (Total 40 min), 5 readings, 18 quizzes
24개의 동영상
Overview15
Review of Functions44
Specifying Columns Lists1m
Using a CALL Routine to Modify Data1m
Using Numeric Functions1m
Demo: Using Numeric Functions2m
SAS Date, Datetime, and Time Values53
Extracting Data from a Datetime Value30
Calculating Date Intervals2m
Shifting Date Values50
Demo: Shifting Date Values Based on an Interval3m
Useful Character Functions53
Extracting Words from a String58
Demo: Using Character Functions to Extract Words from a String3m
Searching for Character Strings51
Replacing Character Strings27
Handling Column Type35
Converting Column Type1m
Converting Character Values to Numeric Values1m
Using a Generic Informat to Read Dates1m
Converting the Type of an Existing Column1m
Converting Numeric Values to Character Values1m
Demo: Using the INPUT Function to Convert Column Types7m
Demo: Using the PUT Function to Convert Column Types3m
5개의 읽기 자료
Using Numeric Functions to Change Precision10m
Removing Characters from a String10m
Identifying Character Positions10m
Building Character Strings10m
Syntax Review10m
18개 연습문제
Activity 3.0110m
Activity 3.0210m
Activity 3.0310m
Activity 3.0410m
Question 3.055m
Level 1 Practice: Using the LARGEST and ROUND Functions20m
Level 2 Practice: Working with Date/Time Values20m
Activity 3.0610m
Activity 3.0710m
Activity 3.0810m
Activity 3.0910m
Level 1 Practice: Using the SCAN and PROPCASE Functions20m
Level 2 Practice: Searching for Character Strings20m
Activity 3.1010m
Activity 3.1110m
Question 3.125m
Activity 3.1310m
Manipulating Data with Functions30m
주
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 videos (Total 16 min), 1 reading, 10 quizzes
8개의 동영상
Formatting Data Values29
Creating and Applying a Custom Format2m
Using Ranges1m
Demo: Creating and Using Custom Formats3m
Reading a Table of Values for a Format2m
Demo: Creating Custom Formats from Tables4m
Storing Custom Formats1m
1개의 읽기 자료
Syntax Review10m
10개 연습문제
Activity 4.0110m
Activity 4.0210m
Activity 4.0310m
Level 1 Practice: Creating Custom Formats Based on Single Values20m
Level 2 Practice: Creating Custom Formats Based on a Range of Values20m
Activity 4.0410m
Activity 4.0510m
Level 1 Practice: Creating a Custom Format from a Table20m
Level 2 Practice: Using Conditional Processing to Create a Format from a Table20m
Creating and Using Custom Formats30m
주
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 videos (Total 28 min), 1 reading, 10 quizzes
14개의 동영상
Overview17
Concatenating Tables with Matching Columns1m
Demo: Concatenating Tables3m
Handling Column Attributes45
What is a Merge?1m
Processing a One-to-One Merge2m
Processing a One-To-Many Merge1m
Demo: Merging Tables3m
Merging Tables with Nonmatching Rows2m
Identifying Matches and Nonmatches1m
Demo: Merging Tables with Nonmatching Rows6m
Merging Tables with Matching Column Names1m
Merging Tables without a Common Column1m
DATA Step Merge and PROC SQL Join38
1개의 읽기 자료
Syntax Review10m
10개 연습문제
Activity 5.0110m
Level 1 Practice: Concatenating Like-Structured Tables20m
Level 2 Practice: Concatenating Unlike-Structured Tables20m
Question 5.025m
Activity 5.0310m
Question 5.045m
Activity 5.0510m
Level 1 Practice: Performing a One-to-Many Merge20m
Level 2 Practice: Writing Matches and Nonmatches to Separate Tables20m
Combining Tables30m
주
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 videos (Total 25 min), 1 reading, 7 quizzes
11개의 동영상
Overview13
Processing Repetitive Code50
Iterative DO Loops2m
Demo: Executing an Iterative DO Loop2m
Output Inside and Outside the DO Loop2m
Demo: Using Iterative DO Loops5m
Conditional DO Loops1m
Checking the Condition1m
Demo: Using Conditional DO Loops4m
Combining Iterative and Conditional DO Loops1m
Demo: Combining Iterative and Conditional DO Loops3m
1개의 읽기 자료
Syntax Review10m
7개 연습문제
Activity 6.0110m
Level 1 Practice: Using Nested Iterative DO Loops (DATA Step with No SET Statement)20m
Level 2 Practice: Using an Iterative DO Loop (DATA Step with a SET Statement)20m
Activity 6.0210m
Level 1 Practice: Using a Conditional DO Loop20m
Level 2 Practice: Using an Iterative and Conditional DO Loop20m
Processing Repetitive Code30m
주
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 videos (Total 12 min), 1 reading, 9 quizzes
10개의 동영상
Overview14
Understanding Table Structure46
Restructuring Data36
Demo: Creating a Narrow Table with the DATA Step3m
Creating a Wide Table with the DATA Step44
The Transpose Procedure24
Transposing Values within Groups48
Demo: Creating a Wide Table with PROC TRANSPOSE4m
Creating a Narrow Table with PROC TRANSPOSE27
Changing Column Names59
1개의 읽기 자료
Syntax Review10m
9개 연습문제
Question 7.015m
Activity 7.0210m
Level 1 Practice: Restructuring a Table Using the DATA Step: Wide to Narrow20m
Level 2 Practice: Restructuring a Table Using the DATA Step: Narrow to Wide20m
Activity 7.0310m
Activity 7.0410m
Level 1 Practice: Restructuring a Table Using PROC TRANSPOSE: Wide to Narrow20m
Level 2 Practice: Restructuring a Table Using PROC TRANSPOSE: Narrow to Wide20m
Restructuring Tables30m
4.8
12개의 리뷰최상위 리뷰
I love the way the course content builds on itself in such a systematic way, and welcome the variety of exercises and practices.
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
강사
Stacey Syphus
Senior ManagerEducation
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.
자주 묻는 질문
강의 및 과제를 언제 이용할 수 있게 되나요?
강좌에 등록하면 바로 모든 비디오, 테스트 및 프로그래밍 과제(해당하는 경우)에 접근할 수 있습니다. 상호 첨삭 과제는 이 세션이 시작된 경우에만 제출하고 검토할 수 있습니다. 강좌를 구매하지 않고 살펴보기만 하면 특정 과제에 접근하지 못할 수 있습니다.
이 전문 분야를 구독하면 무엇을 이용할 수 있나요?
강좌를 등록하면 전문 분야의 모든 강좌에 접근할 수 있고 강좌를 완료하면 수료증을 취득할 수 있습니다. 전자 수료증이 성취도 페이지에 추가되며 해당 페이지에서 수료증을 인쇄하거나 LinkedIn 프로필에 수료증을 추가할 수 있습니다. 강좌 내용만 읽고 살펴보려면 해당 강좌를 무료로 청강할 수 있습니다.
환불 규정은 어떻게 되나요?
재정 지원을 받을 수 있나요?
궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.
Coursera는 세계 최고의 교육에 대한 보편적인 접근 기회를 제공하며,
최고의 대학 및 기관들과 제휴하여 온라인 강좌를 제공합니다.
© 2019 Coursera Inc. All rights reserved.
