|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/sas-programming-basics
课程评论：没有评论
课程名称：SAS编程入门 课程概述：本课程适合希望学习如何编写SAS程序以访问、探索、准备和分析数据的用户。它是学习数据科学、机器学习和人工智能中SAS编程的入门课程，并且是许多其他SAS课程的先修课程。课程结束时，学员将掌握如何使用SAS Studio编写和提交SAS程序，访问SAS、Microsoft Excel和文本数据，探索和验证数据，数据准备，包括筛选行和计算新列，数据分析和报告，结果导出到其他格式，使用SQL在SAS中查询和连接表。 先修条件：学员需具备计算机软件使用经验，能够理解文件结构和系统命令，并能访问操作系统上的数据文件。无需先前的SAS经验。 课程大纲： 1. 课程概述与数据设置：学习课程内容，并设置所需的数据进行实践。 2. 基础知识：掌握SAS编程工具及SAS程序结构和语法的基本要素。 3. 数据访问：识别SAS表的特征，通过SAS库访问数据并导入数据。 4. 数据探索与验证：使用SAS过程获得数据洞察，学会如何子集数据、格式化数据和排序数据以解决重复值问题。 5. 数据准备：进行常见的数据操作，例如过滤行列、计算新列和条件处理。 6. 数据分析与报告：总结数据，使用之前探索数据时接触过的SAS过程，以及使用标题、列标签、脚注和宏变量增强报告的意义。 7. 结果导出：将SAS表和结果导出到Excel、Microsoft Word和PDF文件中。 8. 在SAS中使用SQL：学习使用SQL过程读取和过滤数据，并创建和连接表。 通过本课程的学习，学员将能够熟练掌握SAS编程的基础知识，为后续更深入的数据分析课程打下坚实基础。
Name:Course Overview and Data Setup
Description:In this module you learn about the course and you set up the data you need to do the practices in the course.
Name:Essentials
Description:In this module you learn how to use SAS programming tools and the fundamentals of SAS program structure and syntax.
Name:Accessing Data
Description:In this module, you learn to identify the features of a SAS table, access data through SAS libraries, and import data into SAS.
Name:Exploring and Validating Data
Description:In this module, you learn to use SAS procedures that provide insights about your data. You also learn to subset data so you can focus on particular segments, format data so you can easily understand it, and sort data to identify and resolve duplicate values.
Name:Preparing Data
Description:In this module, you learn how to do some common data manipulations, such as filtering rows and columns, computing new columns, and performing conditional processing.
Name:Analyzing and Reporting on Data
Description:In this module, we concentrate on summarizing data by using the SAS procedures that we touched on for data exploration. You also learn how to use titles, column labels, footnotes, and macro variables to enhance your reports and make them more meaningful.
Name:Exporting Results
Description:In this module, you learn to export SAS tables and results to Excel, Microsoft Word, and PDF files.
Name:Using SQL in SAS
Description:In this module, you learn to use the SQL procedure to read and filter data. You also learn to create and join tables by using SQL.
This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. It is a prerequisite to many other SAS courses. By the end of this course, you will know how to use SAS Studio to write and submit SAS programs that access SAS, Microsoft Excel, and text data. You will know how to explore and validate data, prepare data by subsetting rows and computing new columns, analyze and report on data, export data and results to other formats, use SQL in SAS to query and join tables. Prerequisites: Learners should have experience using computer software. Specifically, you should be able to understand file structures and system commands on your operating systems and access data files on your operating systems. No prior SAS experience is needed.
