К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Doing More with SAS Programming · LearnSpace
Назад в каталог
courseraАнализ данных

Doing More with SAS Programming

Курс от SAS
Средний≈ 23.4 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

SAS (Software)Data ManipulationData ProcessingData TransformationStatistical ProgrammingData PresentationData ManagementData AnalysisData IntegrationData WranglingCode Reusability

Программа курса

8 модулей · 182 учебных материалов

01Course Overview and Data Setup6 материалов

Course Overview and Logistics

Welcome to the Course!ВидеоLearner PrerequisitesЧтениеUsing the Community Forum and Getting HelpЧтение

Access SAS Software and Set Up Data for the Course (REQUIRED)

Practicing in This CourseВидео

Учитесь у экспертов

Stacey Syphus

Director

Doing More with SAS Programming
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 23.4 ч

8 модулей

Язык: Английский

Субтитры: Арабский, Французский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Вьетнамский, Нидерландский, Корейский, Немецкий, Пушту, Русский, Тайский, Индонезийский, Шведский, Турецкий, Испанский, Дари, Хинди, Японский, Казахский, Персидский, Венгерский, Польский

Часть программы вашего университета
Access SAS Software and Set Up Practice Files (REQUIRED)Чтение
Frequently Asked QuestionsЧтение
02Controlling DATA Step Processing24 материалов

Module Overview

Overview: Controlling DATA Step ProcessingВидео

Understanding DATA Step Processing

DATA Step ReviewВидеоActivity 1.01 ЗаданиеDATA Step ProcessingВидеоDATA Step Processing: CompilationВидеоDATA Step Processing: ExecutionВидеоDemo: DATA Step Processing in ActionВидеоViewing Execution in the LogВидеоActivity 1.02ЗаданиеPractice: Using PUTLOG Statements to Examine Execution StepsЗадание

Directing DATA Step Output

Controlling DATA Step ProcessingВидеоActivity 1.03ЗаданиеImplicit and Explicit OutputВидеоActivity 1.04ЗаданиеSending Output to Multiple TablesВидеоDemo: Directing Row OutputВидеоControlling Column Output

Module Review

Syntax Review: Controlling DATA Step ProcessingЧтениеControlling DATA Step ProcessingЗадание
03Summarizing Data22 материалов

Module Overview

Overview: Summarizing DataВидео

Creating an Accumulating Column

Demo: Creating an Accumulating ColumnВидеоRetaining Values in the PDVВидеоActivity 2.01ЗаданиеUsing the Sum StatementВидеоQuestion 2.02ЗаданиеLevel 1 Practice: Producing a Running Total ЗаданиеLevel 2 Practice: Producing Multiple TotalsЗадание

Processing Data in Groups

Answering Questions about GroupsВидеоProcessing Sorted Data in GroupsВидеоDemo: Identifying the First and Last Row in Each GroupВидеоActivity 2.03ЗаданиеSubsetting Rows in the Execution PhaseВидеоActivity 2.04Задание

Module Review

Syntax Review: Summarizing DataЧтениеSummarizing DataЗадание
04Manipulating Data with Functions47 материалов

Module Overview

Overview: Manipulating Data with FunctionsВидео

Understanding SAS Functions and CALL Routines

Review of FunctionsВидеоActivity 3.01 ЗаданиеSpecifying Columns ListsВидеоUsing a CALL Routine to Modify DataВидеоActivity 3.02 Задание

Using Numeric and Date Functions

Using Numeric FunctionsВидеоDemo: Using Numeric FunctionsВидеоUsing Numeric Functions to Change PrecisionЧтениеActivity 3.03 ЗаданиеSAS Date, Datetime, and Time ValuesВидеоExtracting Data from a Datetime ValueВидео

Using Character Functions

Useful Character FunctionsВидеоRemoving Characters from a StringЧтениеActivity 3.06 ЗаданиеExtracting Words from a StringВидеоDemo: Using Character Functions to Extract Words from a StringВидеоActivity 3.07Задание

Using Special Functions to Convert Column Type

Handling Column TypeВидеоActivity 3.10 ЗаданиеConverting Column TypeВидеоConverting Character Values to Numeric ValuesВидеоUsing a Generic Informat to Read DatesВидеоActivity 3.11 Задание

Module Review

Syntax Review: Manipulating Data with FunctionsЧтениеManipulating Data with FunctionsЗадание
05Creating and Using Custom Formats19 материалов

Module Overview

Overview: Creating and Using Custom FormatsВидео

Creating and Using Custom Formats

Formatting Data ValuesВидеоActivity 4.01ЗаданиеCreating and Applying a Custom FormatВидеоActivity 4.02 ЗаданиеUsing RangesВидеоDemo: Creating and Using Custom FormatsВидеоActivity 4.03 ЗаданиеLevel 1 Practice: Creating Custom Formats Based on Single Values ЗаданиеLevel 2 Practice: Creating Custom Formats Based on a Range of Values Задание

Creating Custom Formats from Tables

Reading a Table of Values for a FormatВидеоDemo: Creating Custom Formats from TablesВидеоActivity 4.04ЗаданиеStoring Custom FormatsВидеоActivity 4.05 ЗаданиеLevel 1 Practice: Creating a Custom Format from a TableЗадание

Module Review

Syntax Review: Creating and Using Custom FormatsЧтениеCreating and Using Custom FormatsЗадание
06Combining Tables25 материалов

Module Overview

OverviewВидео

Concatenating Tables

Concatenating Tables with Matching ColumnsВидеоDemo: Concatenating TablesВидеоActivity 5.01 ЗаданиеHandling Column AttributesВидеоLevel 1 Practice: Concatenating Like-Structured TablesЗаданиеLevel 2 Practice: Concatenating Unlike-Structured Tables Задание

Merging Tables

What is a Merge?ВидеоQuestion 5.02 ЗаданиеProcessing a One-to-One MergeВидеоActivity 5.03 ЗаданиеProcessing a One-To-Many MergeВидеоDemo: Merging TablesВидео

Identifying Matching and Nonmatching Rows

Merging Tables with Nonmatching RowsВидеоIdentifying Matches and NonmatchesВидеоQuestion 5.04 ЗаданиеDemo: Merging Tables with Nonmatching RowsВидеоActivity 5.05 ЗаданиеMerging Tables with Matching Column NamesВидео

Module Review

Syntax Review: Combining TablesЧтениеCombining TablesЗадание
07Processing Repetitive Code19 материалов

Module Overview

Overview: Processing Repetitive CodeВидео

Using Iterative DO Loops

Processing Repetitive CodeВидеоIterative DO LoopsВидеоDemo: Executing an Iterative DO LoopВидеоActivity 6.01ЗаданиеOutput Inside and Outside the DO LoopВидеоDemo: Using Iterative DO LoopsВидеоLevel 1 Practice: Using Nested Iterative DO Loops (DATA Step with No SET Statement)ЗаданиеLevel 2 Practice: Using an Iterative DO Loop (DATA Step with a SET Statement) Задание

Using Conditional DO Loops

Conditional DO LoopsВидеоActivity 6.02 ЗаданиеChecking the ConditionВидеоDemo: Using Conditional DO LoopsВидеоCombining Iterative and Conditional DO LoopsВидеоDemo: Combining Iterative and Conditional DO LoopsВидео

Module Review

Syntax Review: Processing Repetitive CodeЧтениеProcessing Repetitive CodeЗадание
08Restructuring Tables20 материалов

Module Overview

OverviewВидео

Restructuring Data with the DATA Step

Understanding Table StructureВидеоQuestion 7.01 ЗаданиеRestructuring DataВидеоDemo: Creating a Narrow Table with the DATA StepВидеоCreating a Wide Table with the DATA StepВидеоActivity 7.02 ЗаданиеLevel 1 Practice: Restructuring a Table Using the DATA Step: Wide to Narrow ЗаданиеLevel 2 Practice: Restructuring a Table Using the DATA Step: Narrow to WideЗадание

Restructuring Data with the TRANSPOSE Procedure

The Transpose ProcedureВидеоActivity 7.03 ЗаданиеTransposing Values within GroupsВидеоDemo: Creating a Wide Table with PROC TRANSPOSEВидеоCreating a Narrow Table with PROC TRANSPOSEВидеоActivity 7.04 Задание

Module Review

Syntax Review: Restructuring TablesЧтениеRestructuring TablesЗадание
Видео
Demo: Directing Column OutputВидео
Columns in the PDVВидео
Question 1.05 Задание
Level 1 Practice: Conditionally Creating Multiple Output Tables Задание
Level 2 Practice: Conditionally Creating Columns and Output TablesЗадание
Demo: Creating an Accumulating Column within GroupsВидео
Activity 2.05 Задание
Using Multiple BY ColumnsВидео
Question 2.06 Задание
Level 1 Practice: Generating an Accumulating Column within Groups Задание
Level 2 Practice: Generating an Accumulating Column within Multiple GroupsЗадание
Calculating Date IntervalsВидео
Activity 3.04 Задание
Question 3.05Задание
Shifting Date ValuesВидео
Demo: Shifting Date Values Based on an IntervalВидео
Level 1 Practice: Using the LARGEST and ROUND Functions Задание
Level 2 Practice: Working with Date/Time ValuesЗадание
Searching for Character StringsВидео
Activity 3.08 Задание
Identifying Character PositionsЧтение
Replacing Character StringsВидео
Building Character StringsЧтение
Activity 3.09Задание
Level 1 Practice: Using the SCAN and PROPCASE Functions Задание
Level 2 Practice: Searching for Character StringsЗадание
Converting the Type of an Existing ColumnВидео
Question 3.12 Задание
Converting Numeric Values to Character ValuesВидео
Demo: Using the INPUT Function to Convert Column TypesВидео
Demo: Using the PUT Function to Convert Column TypesВидео
Activity 3.13 Задание
Level 2 Practice: Using Conditional Processing to Create a Format from a Table Задание
Merging Tables without a Common ColumnВидео
DATA Step Merge and PROC SQL JoinВидео
Level 1 Practice: Performing a One-to-Many Merge Задание
Level 2 Practice: Writing Matches and Nonmatches to Separate Tables Задание
Level 1 Practice: Using a Conditional DO Loop Задание
Level 2 Practice: Using an Iterative and Conditional DO LoopЗадание
Changing Column NamesВидео
Level 1 Practice: Restructuring a Table Using PROC TRANSPOSE: Wide to Narrow Задание
Level 2 Practice: Restructuring a Table Using PROC TRANSPOSE: Narrow to Wide Задание