提供：
Course Description
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.
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.
In this module, you learn about the Structured Query Language (SQL) and begin exploring data using the SQL procedure in SAS.
In this module, you learn the fundamentals of SQL by using the SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY clauses. You generate simple queries, group and summarize data, create and manage tables, and retrieve information about your SAS session using DICTIONARY tables.
In this module, you learn about joining data horizontally from multiple tables using the Cartesian product. You learn how to perform INNER, OUTER and complex joins.
In this module, you learn about using subqueries, or a query within a query. You begin by using a subquery in the WHERE or HAVING clause to dynamically subset your data, then you use a query in the FROM clause (In-Line view) to act as a virtual table. Finally, you use a subquery in the SELECT clause to perform dynamic calculations.
Great course! If you can follow this course, you will be no problem on SAS advanced certificate! The contents are much more indepth than the exam requirement!
It was an amazing experience learning from coursera. Truly one of the best. I just wish that they had provided with more of practice exercises for each topic .
Good instructions, videos, quizzes, and assignments. Instructors also provided additional resources. So much easier using SQL in SAS than standard SAS language.
Concise lectures, relevant exercises/quizzes, fun case study project, and prompt discussion forum help! 100% recommended!
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.
いつ講座や課題にアクセスできるようになりますか？
この修了証をサブスクライブすると何を行うことができるようになりますか？
さらに質問がある場合は、受講者ヘルプセンターにアクセスしてください。
