The first part of the courses teaches you SQL as it relates to the SAS programming language. In other words, you will learn SAS SQL. ! SQL is especially utilized for extracting/selecting data from database tables, and also manipulating that data.
The second part of the course introduces you to Indices and Macro programming. In this course, you will improve your system performance by learning how to create Indices in a number of different ways, and you will create macro programs that will help you cut down on repetitive coding, which helps you save time and money.
Some of the things you will gain skills in:
create, update, and utilize Indexes.
create a logistic regression macro program.
create a macro that prints different reports depending on the day.
create a macro that calculates statistics for multiple years.