|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/sas-macro-language
课程评论：没有评论
课程名称：SAS宏语言 概述：在本课程中，您将学习数据步骤和过程中的高级技术，以便对数据进行操作。 课程学习目标： 通过本课程的学习，学员将能够： - 在SAS代码中执行文本替换。 - 使用宏变量和宏函数。 - 自动化和定制SAS代码的生成。 - 有条件或迭代地构建SAS代码。 - 编写自我修改和数据驱动的程序。 课程大纲： 1. 引言模块： - 该模块将提供课程的概述并设置实践文件，您将探索宏编程及其对SAS编程工作的帮助。 2. SAS宏设施： - 在这一模块中，您将学习SAS如何在后台处理代码。掌握SAS宏设施的关键在于理解宏语言元素如何影响代码处理，并学习如何创建和使用宏变量动态修改程序文本。 3. 存储和处理文本： - 本模块将帮助您了解更多关于文本存储和处理的内容。您将学习使用宏函数来操作文本，以及如何使用PROC SQL和DATA步骤根据数据中的值创建宏变量。同时，您还将学习如何使用间接引用查找基于另一个宏变量值的宏变量。 4. 与宏程序的工作： - 在本模块中，您将学习如何编写和调用宏程序，根据输入值生成SAS代码。您还将了解宏变量的作用域，即宏变量存储的位置及其可用时间。最后，您将学习如何使用宏IF/THEN语句有条件地生成和处理代码，以及使用宏DO循环进行迭代处理。 5. 开发宏应用程序： - 本模块帮助您学习如何存储和检索宏，以便在任何SAS会话中可用。您将学习构建数据驱动的宏应用程序，根据数据中的值动态生成SAS代码。同时，您还将学习如何在宏应用程序中加入安全预防措施和文档，以便在出现问题时自我修正或提供指导信息。 6. 案例研究（荣誉）和认证模拟考试： - 在本案例研究中，您将通过应用本课程中所学的概念来解决实际的商业问题。
Name:Introduction
Description: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.
Name:SAS Macro Facility
Description: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.
Name:Storing and Processing Text
Description: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.
Name:Working with Macro Programs
Description: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.
Name:Developing Macro Applications
Description: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.
Name:Case Study (Honors) and Certification Practice Exam
Description:In this case study, you solve a real-world business problem by applying concepts that you learned in this course.
In this course, you learn advanced techniques within the DATA step and procedures to manipulate data. Course Learning Objectives: (3+ per course) “By the end of this course, a learner will be able to…” ● Perform text substitution in SAS code. ● Use macro variables and macro functions. ● Automate and customize the production of SAS code. ● Conditionally or iteratively construct SAS code. ● Write self-modifying, data-driven programs.
