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

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

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

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

Getting Started with SAS Programming

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

О курсе

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.

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

SAS (Software)Data Import/ExportData ManipulationData ValidationSQLData PreprocessingData PresentationDescriptive StatisticsStatistical ReportingData AccessExploratory Data AnalysisData TransformationStatistical ProgrammingData Analysis SoftwareData AnalysisMicrosoft Excel

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

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

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

Course Overview and Logistics

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

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

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

Stacey Syphus

Director

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 22.3 ч

8 модулей

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

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

Часть программы вашего университета
Practicing in This CourseВидео
Access SAS Software and Set Up Practice Files (REQUIRED)Чтение
Frequently Asked QuestionsЧтение
02Essentials12 материалов

Module Overview

Overview: EssentialsВидео

Using SAS Programming Tools

SAS Programming InterfacesВидеоDemo: Programming with SAS StudioВидеоPractice Using SAS StudioЧтение

Understanding SAS Syntax

SAS Program StructureВидеоActivity 1.1ЗаданиеSAS Program SyntaxВидеоDemo: Understanding SAS Program SyntaxВидеоDemo: Finding and Resolving Syntax ErrorsВидеоActivity 1.2 Задание

Review

Syntax Review: EssentialsЧтениеEssentials ReviewЗадание
03Accessing Data23 материалов

Module Overview

Overview: Accessing DataВидео

Understanding SAS Data

Types of DataВидеоWhat is a SAS Table?ВидеоRequired Column Attributes for SAS TablesВидеоActivity 2.1 ЗаданиеListing Table and Column AttributesВидеоActivity 2.2 Задание

Accessing Data Through Libraries

Accessing Data in a ProgramВидеоUsing a Library to Read SAS DataВидеоActivity 2.3: Create a Library for this Course (Required) ЗаданиеAutomatic SAS LibrariesВидеоDemo: Exploring Automatic SAS LibrariesВидеоUsing a Library to Read Other File TypesВидео

Importing Data into SAS

Importing Unstructured DataВидеоDemo: Importing a Comma-Delimited (CSV) FileВидеоActivity 2.5ЗаданиеImporting an Excel FileВидеоLevel 1 Practice: Importing Excel Data from a Single Worksheet ЗаданиеLevel 2 Practice: Importing Data from a CSV FileЗадание

Review

Syntax Review: Accessing DataЧтениеAccessing DataЗадание
04Exploring and Validating Data30 материалов

Module Overview

Overview: Exploring and Validating DataВидео

Exploring Data

Exploring Data with ProceduresВидеоActivity 3.1 ЗаданиеDemo: Exploring Data with SAS ProceduresВидеоLevel 1 Practice: Exploring Data with ProceduresЗаданиеLevel 2 Practice: Using Procedures to Validate Data Задание

Filtering Rows

Filtering Rows with the WHERE StatementВидеоCombining Expressions in a WHERE StatementВидеоDemo: Filtering Rows with Basic OperatorsВидеоUsing Special WHERE OperatorsВидеоActivity 3.2 ЗаданиеCreating and Using Macro VariablesВидео

Formatting Columns

Formatting Data Values in ResultsВидеоCommon Formats for Numeric ValuesВидеоActivity 3.4 ЗаданиеCommon Formats for Date ValuesВидеоDemo: Formatting Data Values in ResultsВидеоActivity 3.5 Задание

Sorting Data and Removing Duplicates

Sorting DataВидеоActivity 3.6 ЗаданиеIdentifying and Removing DuplicatesВидеоDemo: Identifying and Removing Duplicate ValuesВидеоLevel 1 Practice: Sorting Data and Creating an Output Table ЗаданиеLevel 2 Practice: Sorting Data to Remove Duplicate Rows Задание

Review

Syntax Review: Exploring and Validating DataЧтениеExploring and Validating DataЗадание
05Preparing Data31 материалов

Module Overview

Overview: Preparing DataВидео

Reading and Filtering Data

Using the DATA Step to Create a SAS Data SetВидеоDATA Step ProcessingВидеоDemo: Working with the DATA StepВидеоActivity 4.1ЗаданиеLevel 1 Practice: Creating a SAS Table ЗаданиеLevel 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table Задание

Computing New Columns

Demo: Using Expressions to Create New ColumnsВидеоActivity 4.2 ЗаданиеUsing Numeric Functions to Create ColumnsВидеоCommon Summary Functions for Creating ColumnsЧтениеActivity 4.3 ЗаданиеCommon Character Functions for Creating ColumnsЧтение

Conditional Processing

Demo: Conditional Processing with IF-THENВидеоConditional Processing with IF-THEN/ELSEВидеоActivity 4.5ЗаданиеCreating Character Columns with the LENGTH StatementВидеоActivity 4.6ЗаданиеProcessing Multiple Statements with IF-THEN/DOВидео

Review

Syntax Review: Preparing DataЧтениеPreparing DataЗадание
06Analyzing and Reporting on Data23 материалов

Module Overview

Overview: Analyzing and Reporting on DataВидео

Enhancing Reports with Titles, Footnotes, and Labels

Using Titles and FootnotesВидеоActivity 5.1ЗаданиеUsing Macro Variables and Functions in Titles and FootnotesВидеоApplying Temporary Labels to ColumnsВидеоSegmenting ReportsВидеоDemo: Enhancing ReportsВидеоApplying Permanent Labels to ColumnsВидеоActivity 5.2 Задание

Creating Frequency Reports

Demo: Creating Frequency Reports and GraphsВидеоActivity 5.3ЗаданиеDemo: Creating Two-Way Frequency ReportsВидеоLevel 1 Practice: Creating One-Way Frequency Reports ЗаданиеLevel 2 Practice: Creating Two-Way Frequency ReportsЗадание

Creating Summary Reports and Data

Demo: Creating a Summary Statistics ReportВидеоActivity 5.4ЗаданиеCreating an Output Summary TableВидеоActivity 5.5 ЗаданиеLevel 1 Practice: Producing a Descriptive Statistics Report ЗаданиеLevel 2 Practice: Creating an Output Table with Custom Columns Задание

Review

Syntax Review: Analyzing and Reporting on DataЧтениеAnalyzing and Reporting on DataЗадание
07Exporting Results17 материалов

Module Overview

Overview: Exporting ResultsВидео

Exporting Data

Exporting DataВидеоCreate a Macro Variable (REQUIRED)ЗаданиеActivity 6.1ЗаданиеDemo: Exporting Data to an Excel WorkbookВидеоActivity 6.2Задание

Exporting Reports

Using the SAS Output Delivery SystemВидеоExporting Results to CSVВидеоDemo: Exporting Results to ExcelВидеоActivity 6.3ЗаданиеExporting Results to PowerPoint and Microsoft WordВидеоActivity: Create PowerPoint and RTF FilesЧтениеDemo: Exporting Results to PDFВидеоLevel 1 Practice: Creating an Excel File Using ODS EXCEL ЗаданиеLevel 2 Practice: Creating a Document with ODS RTF Задание

Review

Syntax Review: Exporting ResultsЧтениеExporting Results Задание
08Using SQL in SAS15 материалов

Module Overview

Overview: Using SQL in SASВидео

Using Structured Query Language (SQL) in SAS

SQL and SASВидеоPROC SQL SyntaxВидеоActivity 7.1 ЗаданиеFiltering and Sorting OutputВидеоDemo: Reading and Filtering Data with SQLВидеоActivity 7.2ЗаданиеCreating and Deleting Tables in SQLВидео

Joining Tables Using SQL in SAS

Creating Inner Joins in SQLВидеоDemo: Joining Tables with PROC SQLВидеоUsing Table AliasesВидеоActivity 7.3 Задание

Review

Syntax Review: Using SQL in SASЧтениеUsing SQL in SASЗадание

Course Wrap Up

You've Finished the Course!Видео
Demo: Using a Library to Read Excel FilesВидео
Activity 2.4 Задание
Demo: Filtering Rows Using Macro VariablesВидео
Activity 3.3 Задание
Level 1 Practice: Filtering Rows in a Listing Report Using Character Data Задание
Level 2 Practice: Using Macro Variables to Subset Data in ProceduresЗадание
Demo: Using Character FunctionsВидео
Activity 4.4Задание
Common Date Functions for Creating ColumnsЧтение
Demo: Using Date FunctionsВидео
Level 1 Practice: Creating New Columns Задание
Level 2 Practice: Creating New Columns with Character and Date Functions Задание
Activity 4.7Задание
Demo: Processing Multiple Statements with IF-THEN/DOВидео
Level 1 Practice: Processing Statements with IF-THEN/ELSE Задание
Level 2 Practice: Processing Statements Conditionally with DO Groups Задание
Examples of Procedures that Analyze DataЧтение