In this course, you learn advanced techniques within the DATA step and procedures to manipulate data.
提供方
课程信息
20,693 次近期查看
可分享的证书
完成后获得证书
100% 在线
立即开始，按照自己的计划学习。
第 2 门课程（共 3 门）
可灵活调整截止日期
根据您的日程表重置截止日期。
中级
完成时间大约为18 小时
英语（English）
字幕：英语（English）
可分享的证书
完成后获得证书
100% 在线
立即开始，按照自己的计划学习。
第 2 门课程（共 3 门）
可灵活调整截止日期
根据您的日程表重置截止日期。
中级
完成时间大约为18 小时
英语（English）
字幕：英语（English）
提供方
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.
教学大纲 - 您将从这门课程中学到什么
完成时间为 1 小时
Introduction
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.
完成时间为 1 小时
5 个视频 （总计 5 分钟）, 4 个阅读材料
5 个视频
Introduction14
Benefits of Using SAS Macro2分钟
Efficiency of Macro-Based Applications17
Developing Macro Applications54
4 个阅读材料
Learner Prerequisites2分钟
Using Forums and Getting Help10分钟
Access SAS Software for this Course10分钟
Set Up Data for This Course 30分钟
完成时间为 2 小时
SAS Macro Facility
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.
完成时间为 2 小时
15 个视频 （总计 22 分钟）
15 个视频
SAS Programming Languages1分钟
Program Flow1分钟
Tokens2分钟
Tokenization1分钟
Tokenizing Code with Macro Triggers2分钟
Macro Variables1分钟
Creating Macro Variables With %LET3分钟
Deleting Macro Variables36
Resolving Macro Variables3分钟
Using SYMBOLGEN to Troubleshoot Macro Variable References38
Delimiting Macro Variable References2分钟
Displaying Macro Variables54
Automatic Macro Variables57
Updating Macro Variables49
11 个练习
Question 2.012分钟
Question 2.022分钟
Question 2.035分钟
Question 2.042分钟
Activity 2.0510分钟
Activity 2.0610分钟
Activity 2.0710分钟
Activity 2.0810分钟
Level 1 Practice: Defining and Using Macro Variables for Substitution20分钟
Level 2 Practice: Using Macro Variable References with Delimiters20分钟
SAS Macro Facility Review 30分钟
完成时间为 5 小时
Storing and Processing Text
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.
完成时间为 5 小时
19 个视频 （总计 49 分钟）
19 个视频
Using Macro Functions1分钟
SAS Functions and Macro Functions2分钟
Processing Text with Macro Functions2分钟
Executing SAS DATA Step Functions During Tokenization1分钟
Evaluating Arithmetic Expressions2分钟
Using Special Characters4分钟
Demo: Using Macro Functions4分钟
Creating Macro Variables in PROC SQL4分钟
Demo: Creating Macro Variables with a PROC SQL Query4分钟
Scenario: Create Macro Variables in a DATA Step1分钟
DATA Step versus Macro Execution Timing1分钟
Creating Macro Variables in a DATA Step2分钟
Creating Macro Variables During DATA Step Execution1分钟
Demo: Creating Macro Variables with the DATA Step3分钟
Comparing the DATA Step and PROC SQL45
Scenario: Using Indirect References2分钟
Forward Rescan Rule2分钟
Demo: Indirect References to Macro Variables4分钟
17 个练习
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分钟
Storing and Processing Text Review 30分钟
完成时间为 5 小时
Working with Macro Programs
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.
完成时间为 5 小时
29 个视频 （总计 63 分钟）
29 个视频
Defining a Macro2分钟
Using the MCOMPILENOTE Option20
Calling a Macro1分钟
Using the MPRINT Option43
Macro Parameters1分钟
Demo: Defining a Macro with Parameters3分钟
Macro Keyword Parameters2分钟
Mixed Parameter Lists57
Global Macro Variables1分钟
Local Macro Variables1分钟
Macro Variable Scope1分钟
Controlling Macro Variable Scope3分钟
Resolving Macro Variables1分钟
Nested Macro Calls4分钟
Conditional Processing3分钟
Conditionally Executing Program Steps1分钟
Scenario: Nested Conditional Processing1分钟
Conditionally Generating Program Steps3分钟
Conditionally Generating Complete and Partial Statements1分钟
Using the MLOGIC Option36
Demo: Conditional Processing5分钟
Scenario: Generating Repetitive Code49
%DO Iterative Statement3分钟
Demo: Iterative %DO Loops3分钟
Using a %DO Loop with Indirect References2分钟
Demo: %DO Loops with Indirect References3分钟
%DO WHILE Loops2分钟
%DO UNTIL Loops41
19 个练习
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分钟
Working with Macro Programs Review30分钟
关于 SAS Advanced Programmer 专业证书
When you complete this professional certificate program, you will have experience in SAS programming using SAS 9 and will be able to process data using Structured Query Language in the SAS environment, use the SAS macro facility to design, write, and debug dynamic macro programs, and use advanced DATA step techniques and procedures to manipulate data. These skills prepare you for the SAS Advanced Programming Professional certification exam.
常见问题
我什么时候能够访问课程视频和作业？
讲座和作业的访问权限取决于您的注册类型。如果您以旁听模式参加课程，则可以免费查看大多数课程资料。要访问评分作业并获得证书，您需要在旁听期间或之后购买证书体验。如果看不到旁听选项：
- 课程可能不提供旁听选项。您可以尝试免费试用，也可以申请助学金。
- 课程可能会改为提供'完整课程，没有证书'。通过此选项，您可以查看所有课程材料、提交所要求的作业，以及获得最终成绩。这也意味着您将无法购买证书体验。
我订阅此证书后会得到什么？
您注册课程后，将有权访问证书中的所有课程，并且会在完成作业后获得证书。您的电子证书将添加到您的成就页中，您可以通过该页打印证书或将其添加到您的领英档案中。如果您只想阅读和查看课程内容，可以免费旁听课程。
What is the refund policy?
如果订阅，您可以获得 7 天免费试听，在此期间，您可以取消课程，无需支付任何罚金。在此之后，我们不会退款，但您可以随时取消订阅。请阅读我们完整的退款政策。
还有其他问题吗？请访问 学生帮助中心。
