SAS Macro Language

本课程是 SAS Advanced Programmer 专业证书的一部分

位教师：Stacey Syphus

访问权限由 Coursera Learning Team 提供

8,002 人已注册

6个模块

深入了解一个主题并学习基础知识。

149 条评论

中级等级

需要一些相关经验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

6个模块

深入了解一个主题并学习基础知识。

149 条评论

中级等级

需要一些相关经验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将获得的技能

要了解的详细信息

可分享的证书

添加到您的领英档案

作业

60 项作业

授课语言：英语（English）

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

积累 Software Development 领域的专业知识

本课程是 SAS Advanced Programmer 专业证书专项课程的一部分

在注册此课程时，您还会同时注册此专业证书。

向行业专家学习新概念
获得对主题或工具的基础理解
通过实践项目培养工作相关技能
通过 SAS 获得可共享的职业证书

该课程共有6个模块

In this course, you learn advanced techniques within the DATA step and procedures to manipulate data.

In this module you'll get an overview of this course and set up your practice files. Then you'll explore macro programming and learn what the macro facility will enable you to do and why it can make your job as a SAS programmer easier.

涵盖的内容

5个视频5篇阅读材料

5个视频总计5分钟

Course Overview 1分钟
Introduction 0分钟
Benefits of Using SAS Macro 2分钟
Efficiency of Macro-Based Applications 0分钟
Developing Macro Applications 1分钟

5篇阅读材料总计57分钟

Learner Prerequisites 2分钟
Using Forums and Getting Help 5分钟
Access SAS Software for this Course 10分钟
Set Up Data for This Course 30分钟
Frequently Asked Questions 10分钟

In this module, you learn how SAS processes code behind the scenes. This is important because mastering the SAS macro facility is only possible if you understand how macro language elements impact this processing. You also learn how to create and use macro variables to dynamically modify text in a program.

涵盖的内容

15个视频11个作业

15个视频总计22分钟

Introduction 0分钟
SAS Programming Languages 1分钟
Program Flow 1分钟
Tokens 2分钟
Tokenization 1分钟
Tokenizing Code with Macro Triggers 2分钟
Macro Variables 1分钟
Creating Macro Variables With %LET 3分钟
Deleting Macro Variables 1分钟
Resolving Macro Variables 4分钟
Using SYMBOLGEN to Troubleshoot Macro Variable References 1分钟
Delimiting Macro Variable References 2分钟
Displaying Macro Variables 1分钟
Automatic Macro Variables 1分钟
Updating Macro Variables 1分钟

11个作业总计141分钟

SAS Macro Facility 50分钟
Question 2.01 2分钟
Question 2.02 2分钟
Question 2.03 5分钟
Question 2.04 2分钟
Activity 2.05 10分钟
Activity 2.06 10分钟
Activity 2.07 10分钟
Activity 2.08 10分钟
Level 1 Practice: Defining and Using Macro Variables for Substitution 20分钟
Level 2 Practice: Using Macro Variable References with Delimiters 20分钟

In this module, you learn more about storing and processing text. You learn to use macro functions to manipulate text, and how to use both PROC SQL and the DATA step to create macro variables based on values read from your data. You also learn how to use indirect referencing to look up a macro variable's value based on another macro variable.

涵盖的内容

19个视频17个作业

19个视频总计49分钟

Introduction 1分钟
Using Macro Functions 1分钟
SAS Functions and Macro Functions 3分钟
Processing Text with Macro Functions 2分钟
Executing SAS DATA Step Functions During Tokenization 1分钟
Evaluating Arithmetic Expressions 3分钟
Using Special Characters 5分钟
Demo: Using Macro Functions 4分钟
Creating Macro Variables in PROC SQL 5分钟
Demo: Creating Macro Variables with a PROC SQL Query 4分钟
Scenario: Create Macro Variables in a DATA Step 2分钟
DATA Step versus Macro Execution Timing 2分钟
Creating Macro Variables in a DATA Step 3分钟
Creating Macro Variables During DATA Step Execution 2分钟
Demo: Creating Macro Variables with the DATA Step 4分钟
Comparing the DATA Step and PROC SQL 1分钟
Scenario: Using Indirect References 2分钟
Forward Rescan Rule 2分钟
Demo: Indirect References to Macro Variables 5分钟

17个作业总计274分钟

Storing and Processing Text 50分钟
Activity 3.01 10分钟
Question 3.02 2分钟
Activity 3.03 10分钟
Activity 3.04 10分钟
Level 1 Practice: Using the %UPCASE and %SCAN Functions 20分钟
Level 2 Practice: Using Macro Quoting Functions 20分钟
Level 1 Practice: Using PROC SQL to Generate Macro Variables for Use in a Report Title 20分钟
Level 2 Practice: Using PROC SQL to Generate Macro Variables for Use in Subsequent Steps 20分钟
Activity3.05 10分钟
Question 3.06 2分钟
Activity 3.07 10分钟
Level 1 Practice: Creating Macro Variables with the SYMPUTX Routine 20分钟
Level 2 Practice: Using a DATA _NULL_ Step to Create a Series of Macro Variables 20分钟
Activity 3.08 10分钟
Level 1 Practice: Using Indirect References to Macro Variables 20分钟
Level 2 Practice: Using Indirect References to Macro Variables 20分钟

In this module, you learn to write and call macro programs to generate SAS code based on input values. You also learn about macro variable scope - where macro variables are stored and how long they are available. Finally you learn about conditionally generating and processing code using macro IF/THEN statements, and iterative processing with macro DO loops.

涵盖的内容

29个视频19个作业

29个视频总计63分钟

Introduction 1分钟
Defining a Macro 2分钟
Using the MCOMPILENOTE Option 0分钟
Calling a Macro 2分钟
Using the MPRINT Option 1分钟
Macro Parameters 1分钟
Demo: Defining a Macro with Parameters 4分钟
Macro Keyword Parameters 2分钟
Mixed Parameter Lists 1分钟
Global Macro Variables 2分钟
Local Macro Variables 1分钟
Macro Variable Scope 1分钟
Controlling Macro Variable Scope 3分钟
Resolving Macro Variables 1分钟
Nested Macro Calls 4分钟
Conditional Processing 3分钟
Conditionally Executing Program Steps 2分钟
Scenario: Nested Conditional Processing 1分钟
Conditionally Generating Program Steps 4分钟
Conditionally Generating Complete and Partial Statements 2分钟
Using the MLOGIC Option 1分钟
Demo: Conditional Processing 6分钟
Scenario: Generating Repetitive Code 1分钟
%DO Iterative Statement 4分钟
Demo: Iterative %DO Loops 4分钟
Using a %DO Loop with Indirect References 2分钟
Demo: %DO Loops with Indirect References 4分钟
%DO WHILE Loops 3分钟
%DO UNTIL Loops 1分钟

19个作业总计287分钟

Working with Macro Programs 50分钟
Activity 4.01 10分钟
Activity 4.02 10分钟
Activity 4.03 10分钟
Level 1 Practice: Defining and Using a Macro with Parameters 20分钟
Level 2 Practice: Using a Macro to Generate PROC MEANS Code 20分钟
Question 4.04 2分钟
Activity 4.05 10分钟
Activity 4.06 10分钟
Level 1 Practice: Understanding Symbol Tables 10分钟
Level 2 Practice: Controlling Macro Variable Scope 20分钟
Activity 4.07 10分钟
Activity 4.08 10分钟
Level 1 Practice: Using Macro Conditional Processing to Choose Which SAS Statements are Generated 20分钟
Level 2 Practice: Using Macro Conditional Processing in Open Code 20分钟
Activity 4.09 10分钟
Code Challenge 4.10 5分钟
Level 1 Practice: Using Iterative Processing and Indirect Referencing 20分钟
Level 2 Practice: Using a %DO %UNTIL Loop 20分钟

In this module you learn how to store and retrieve macros so they are available in any SAS session. You also learn to build data-driven macro applications that dynamically generate SAS code based on values in your data. Finally, you learn to build safety precautions and documentation into your macro applications so that they correct themselves if problems occur, or provide helpful messages to direct the user to a resolution.