Udemy – The Complete SAS Programming reference

What you’ll learn
Learn the main components that make up SAS Programming language including DATA STEP, PROC STEPS, PROC SQL, and MACROS.
Every step will be covered to help you become fully functional including: reading from various sources, manipulating, reporting, and exporting
DATA STEP for manipulating dаta: concatenating, merging, subsetting/supersetting, variable assignment, conditional/Loops, Arrays
PROC STEPS: descriptive stats (PROC MEANS, PROC FREQ), reporting (PROC TABULATE), transposing data, formatting data, Importing/Exporting, inferential stats
Essential features of PROC SQL: Aggregate functions, Filtering, Joins, subqueries, Concatenating, similarities and differences with Oracle/MS SQL
How SAS processes data behind the scene: PROGRAM DATA VECTOR (PDV)
Essential elements of MACROS: the HOW and WHY of macros creation, the HOW and WHY of macros quoting
Description
In designing this course, we tried to incorporate the current state of affairs (— in the INTERNET AGE—) when it comes to learning a programming language, where the sheer amount of resources
at our disposal can be both a curse and a blessing. This is no less true for SAS programming. There are more than enough resources for anyone embarking
on the goal of learning or upgrading their skills in SAS to rely on: (1) SAS particularly extensive documentation about all of their products, (2) the dynamically active community of programmers and users and their contributions; (3) the no less important arrays of courses (paid or not) offered, (4) and even the ability to learn from people next to us. We believe that none of these options is either the definitive solution, nor worthless.
However, for a learner, especially those with no prior knowledge about the programming, making the right choices can be both stressful and/or costly.
So we designed this course in a way to allow you to see the forest from steps/far away or from above so to help you build a contextual self-awareness before you step into it. Once, you have a sense of how your achievement will look like when you get there, we are convinced that (1) the journey will be less stressful, (2) any prior investment you have made or any investment you will make on that front will add value to this one. If you follow through our offer and give it a real try, many of the resources, you have found confusing before will likely start to sound valuable for you. In order to balance the need to help you get a complete picture of SAS programming and not make your journey endless, we put a serious emphasis on the WHY: why SAS does something the way it does; we go to the essential elements of each SAS component, so that you learn more than just the mechanics of making it work when you need it.
For example, in preparing the lesson about MACROS, we made sure to answer the following questions, among other things:
– Why do we need macros?
– how do we create macros (the different methods)
– why do we need different methods to create macros? how do the different methods compare?
– and when it comes to these tools, we let you know upfront that there are limitations (don’t even know why we find the need to repeat this to you— everybody knows that there is no such thing as a perfect/bugs free tool when it comes to POGRAMMING). So expect errors and work to fix them; any error you manage to fix yourself is one more stair on your stairways to professional experience. Don’t be afraid of carefully reading your log, then your code again before you throw the towel; the most elementary errors (simple syntax errors, typos…) are the ones that will stick with you the longest in your journey. We highlighted some of those limitations (ex.: macro quoting).
At a high level, here is what we cover:
Part I: SAS Programming components
Lesson 1: DATA STEP
Lesson 2: PROC STEPS
Lesson 3: PROC SQL
Lesson 4: MACROS
******
Part II: SAS Programming Structure
Lesson 1: STEPS and STATEMENTS
Lesson 2: More on DATA STEP
******
Part III: Reading data into SAS
Lesson 1: Reading from various sources
Lesson 2: Reading using INPUT STYLES (raw data)
******
Part IV: SAS Program Data Vector (PDV)
Lesson: PDV
As you can see, we cover most SAS components/programming elements. For each lesson, we start with a few basic notions and expand in level of difficulty throughout the lesson.
Whether you intend to prepare SAS based certification (without going through the usual painful memorization exercise) or list this language on your resume, we are convinced that this course will helps you achieve your goals. A lot of practice exercises were included; they are targeted mostly at people who are acquiring this course with certification (base SAS) in mind.
Who this course is for:
Beginners who are looking for one-stop-shop source to help them navigate the often confusing resources available out there
Intermediates who have made some efforts in learning SAS programming, but who still often struggle making sense of many SAS notions
Individuals who want to list SAS on their resumes confidently

Homepage

https://www.udemy.com/course/the-complete-sas-programming-reference/