|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/sas-programming-advanced
课程评论：没有评论
课程名称：深入SAS编程 课程概述：本课程适合希望学习数据处理技巧的商业分析师和SAS程序员，内容涵盖使用SAS DATA步骤和过程进行数据访问、转换和汇总。该课程基于“初学者SAS编程”课程的概念，并不推荐给初学者。在本课程中，您将学习理解和控制DATA步骤处理、创建累计列和分组处理数据、使用函数操纵数据、转换列类型、创建自定义格式、合并和连接表、处理重复代码，以及重构表格。课程主要涉及基础SAS软件。 参加此课程之前，您需具备编写DATA步骤代码以访问数据、子集行和列、计算新列及条件处理数据的能力。同时，您还应该能够使用SORT过程对表格进行排序并应用SAS格式。 课程大纲： 1. 课程概述与数据设置 - 介绍课程学习内容，并设置软件和数据以用于课程活动和实践。 2. 控制DATA步骤处理 - 深入探讨DATA步骤，学习其背后处理数据的方式，以及如何控制DATA步骤将行输出到新表格的时机和位置。 3. 数据汇总 - 学习新的语法以改变DATA步骤的默认行为，创建累计列（运行总和），分组处理数据以在每个组开始或结束时执行操作。 4. 使用函数操纵数据 - 学习使用新函数操纵数值、日期和字符值，以及将列从一种数据类型转换为另一种数据类型的函数。 5. 创建和使用自定义格式 - 学习如何创建和使用自定义格式，以改善数据在表格或报告中的显示方式。 6. 合并表格 - 全面了解通过DATA步骤合并表格，学习如何连接表格、合并表格，并识别匹配和不匹配的行。 7. 处理重复代码 - 学习通过使用DO循环进行迭代处理来节省时间，创建迭代DO循环和条件DO循环。 8. 表格重构 - 学习转置或重构表格的技术，使用DATA步骤和TRANSPOSE过程重构数据。
Name:Course Overview and Data Setup
Description:In this module you get an overview of what you learn in this course and you set up the software and data you use for activities and practices in the course.
Name:Controlling DATA Step Processing
Description:In this module, we dig deeper into the DATA step. You learn how the DATA step processes data behind the scenes. Then you use this knowledge to control when and where the DATA step outputs rows to new tables.
Name:Summarizing Data
Description:In this module, you learn new syntax that enables you to alter the default behavior of the DATA step to solve a problem. First you learn to create an accumulating column, or in other words generate a running total. Then you learn to process data in groups, so you can perform an action when each group begins or ends.
Name:Manipulating Data with Functions
Description:In this module, you learn to use some new functions that enable you to manipulate numeric, date, and character values. In addition, you learn to use functions that change a column from one data type to another.
Name:Creating and Using Custom Formats
Description:In this module, you learn to create and use custom formats to enhance the way your data is displayed in a table or report.
Name:Combining Tables
Description:In this module, we take a comprehensive look at combining tables by using the DATA step. You learn to concatenate tables, merge tables, and identify matching and nonmatching rows.
Name:Processing Repetitive Code
Description:In this module, you learn to save time by taking advantage of iterative processing with DO loops. First you learn to create an iterative DO Loop, then you learn to create conditional DO loops.
Name:Restructuring Tables
Description:In this module, you learn techniques that can be used to transpose or restructure a table. First you learn to restructure data with the DATA step. Then you learn to restructure data by using the TRANSPOSE procedure.
This course is for business analysts and SAS programmers who want to learn data manipulation techniques using the SAS DATA step and procedures to access, transform, and summarize data. The course builds on the concepts that are presented in the Getting Started with SAS Programming course and is not recommended for beginning SAS software users. In this course you learn how to understand and control DATA step processing, create an accumulating column and process data in groups, manipulate data with functions, convert column type, create custom formats, concatenate and merge tables, process repetitive code, and restructure tables. This course addresses Base SAS software. Before attending this course, you should be able to write DATA step code to access data, subset rows and columns, compute new columns, and process data conditionally. You should also be able to sort tables using the SORT procedure and apply SAS formats.
