When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Certificate?

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

SAS Macro Language

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

位教师：Stacey Syphus

8,094 人已注册

包含在中

了解更多

5个模块

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

150 条评论

中级等级

需要一些相关经验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

5个模块

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

150 条评论

中级等级

需要一些相关经验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将获得的技能

您将学习的工具

SAS (Software)

要了解的详细信息

可分享的证书

添加到您的领英档案

作业

56 项作业

授课语言：英语（English）

91%

of learners achieved a positive career outcome

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

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

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

积累 Software Development 领域的专业知识

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

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

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

该课程共有5个模块

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

单元详情

In this module, you’ll begin with a brief course overview and set up your practice files. You’ll then explore SAS macro programming, including what the macro facility enables you to do and how it can make programming more efficient. You’ll also learn how SAS processes code behind the scenes and how macro language elements affect that processing, then practice creating and using macro variables to dynamically modify text in your programs.

涵盖的内容

20个视频3篇阅读材料7个作业

20个视频总计28分钟

Course Overview1分钟
Introduction0分钟
Benefits of Using SAS Macro2分钟
Efficiency of Macro-Based Applications0分钟
Developing Macro Applications1分钟
Introduction0分钟
SAS Programming Languages1分钟
Program Flow1分钟
Tokens2分钟
Tokenization1分钟
Tokenizing Code with Macro Triggers2分钟
Macro Variables1分钟
Creating Macro Variables With %LET3分钟
Deleting Macro Variables1分钟
Resolving Macro Variables4分钟
Using SYMBOLGEN to Troubleshoot Macro Variable References1分钟
Delimiting Macro Variable References2分钟
Displaying Macro Variables1分钟
Automatic Macro Variables1分钟
Updating Macro Variables1分钟

3篇阅读材料总计22分钟

Learner Prerequisites2分钟
Access SAS Software & Set up Data(REQUIRED)10分钟
Frequently Asked Questions10分钟

7个作业总计127分钟

SAS Macro Facility50分钟
Knowledge Check: Tokens2分钟
Knowledge Check: Program Flow15分钟
Knowledge Check: SYMBOLGEN to Troubleshoot Macro Variable References10分钟
Level 1 Practice: Defining and Using Macro Variables for Substitution20分钟
Knowledge Check: Delimiting, Displaying & Automatic Macro Variables 10分钟
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分钟

Introduction1分钟
Using Macro Functions1分钟
SAS Functions and Macro Functions3分钟
Processing Text with Macro Functions2分钟
Executing SAS DATA Step Functions During Tokenization1分钟
Evaluating Arithmetic Expressions3分钟
Using Special Characters5分钟
Demo: Using Macro Functions4分钟
Creating Macro Variables in PROC SQL5分钟
Demo: Creating Macro Variables with a PROC SQL Query4分钟
Scenario: Create Macro Variables in a DATA Step2分钟
DATA Step versus Macro Execution Timing2分钟
Creating Macro Variables in a DATA Step3分钟
Creating Macro Variables During DATA Step Execution2分钟
Demo: Creating Macro Variables with the DATA Step4分钟
Comparing the DATA Step and PROC SQL1分钟
Scenario: Using Indirect References2分钟
Forward Rescan Rule2分钟
Demo: Indirect References to Macro Variables5分钟

17个作业总计274分钟

Storing and Processing Text50分钟
Activity 3.0110分钟
Question 3.022分钟
Activity 3.0310分钟
Activity 3.0410分钟
Level 1 Practice: Using the %UPCASE and %SCAN Functions20分钟
Level 2 Practice: Using Macro Quoting Functions20分钟
Level 1 Practice: Using PROC SQL to Generate Macro Variables for Use in a Report Title20分钟
Level 2 Practice: Using PROC SQL to Generate Macro Variables for Use in Subsequent Steps20分钟
Activity3.0510分钟
Question 3.062分钟
Activity 3.0710分钟
Level 1 Practice: Creating Macro Variables with the SYMPUTX Routine20分钟
Level 2 Practice: Using a DATA _NULL_ Step to Create a Series of Macro Variables20分钟
Activity 3.0810分钟
Level 1 Practice: Using Indirect References to Macro Variables20分钟
Level 2 Practice: Using Indirect References to Macro Variables20分钟

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分钟

Introduction1分钟
Defining a Macro2分钟
Using the MCOMPILENOTE Option0分钟
Calling a Macro2分钟
Using the MPRINT Option1分钟
Macro Parameters1分钟
Demo: Defining a Macro with Parameters4分钟
Macro Keyword Parameters2分钟
Mixed Parameter Lists1分钟
Global Macro Variables2分钟
Local Macro Variables1分钟
Macro Variable Scope1分钟
Controlling Macro Variable Scope3分钟
Resolving Macro Variables1分钟
Nested Macro Calls4分钟
Conditional Processing3分钟
Conditionally Executing Program Steps2分钟
Scenario: Nested Conditional Processing1分钟
Conditionally Generating Program Steps4分钟
Conditionally Generating Complete and Partial Statements2分钟
Using the MLOGIC Option1分钟
Demo: Conditional Processing6分钟
Scenario: Generating Repetitive Code1分钟
%DO Iterative Statement4分钟
Demo: Iterative %DO Loops4分钟
Using a %DO Loop with Indirect References2分钟
Demo: %DO Loops with Indirect References4分钟
%DO WHILE Loops3分钟
%DO UNTIL Loops1分钟

19个作业总计287分钟

Working with Macro Programs 50分钟
Activity 4.0110分钟
Activity 4.0210分钟
Activity 4.0310分钟
Level 1 Practice: Defining and Using a Macro with Parameters20分钟
Level 2 Practice: Using a Macro to Generate PROC MEANS Code20分钟
Question 4.042分钟
Activity 4.0510分钟
Activity 4.0610分钟
Level 1 Practice: Understanding Symbol Tables10分钟
Level 2 Practice: Controlling Macro Variable Scope20分钟
Activity 4.0710分钟
Activity 4.0810分钟
Level 1 Practice: Using Macro Conditional Processing to Choose Which SAS Statements are Generated20分钟
Level 2 Practice: Using Macro Conditional Processing in Open Code20分钟
Activity 4.0910分钟
Code Challenge 4.105分钟
Level 1 Practice: Using Iterative Processing and Indirect Referencing20分钟
Level 2 Practice: Using a %DO %UNTIL Loop20分钟

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.