SAS Programming: MacrosSQL Diploma

Course details

• Master the fundamentals of SAS Studio and navigate through its interface effortlessly.
• Develop a deep understanding of macro variables, exploring their applications and delving into nested variations.
• Acquire proficiency in SAS Macros, from basic examples to advanced keyword usage and conditional logic.
• Unlock the potential of Proc SQL, gaining expertise in data copying, filtering, sorting, and removing duplicates.
• Harness the power of data merging using Joins, creating macro variables dynamically in the process.

• Section 0-00- Why SAS  

• Section 2-02- SAS Studio through SAS OnDemand- Registration        
• Section 2-03- Logging-in to SAS after installation        
• Section 2-04- SAS Interface and windows  

• Section 3-00- Section Overview – Macros        
• Section 3-01-Macro Variables – introduction        
• Section 3-02-Application of macro variables        
• Section 3-03-01-Nested macro vars        
• Section 3-03-02-More on Ampersand resolutions using a cool example        
• Section 3-04-00-SAS Macros – introduction        
• Section 3-04-01-SAS Macros – Examples        
• Section 3-04-02-Keyword positional and mixed params        
• Section 3-04-03-Conditional Logic in Macros        
• Section 3-05-Macro Functions        
• Section 3-05-Options Statement- mprint-mlogic-symbolgen        
• Section 3-07-Connecting the two worlds – Call Symput – Symget        
• Section - Bringing data into SAS using Import Wizard   Section 3-09-02- Bringing data into SAS using LIBNAME statement        
• Section 3-09-03- Bringing data into SAS using FILENAME    

• Section 4-00- Section Overview – Proc SQL        
• Section 4-01-01-Proc SQL – copying data        
• Section 4-01-02-Proc SQL – filtering data        
• Section 4-01-03-Proc SQL – sorting data        
• Section 4-01-04-Proc SQL – removing duplicates        
• Section 4-02-01-Proc SQL – Union        
• Section 4-02-02-Proc SQL – Except        
• Section 4-02-03-Proc SQL – Intersect        
• Section 4-03-00-Merging data using Joins-Introduction        
• Section 4-03-01-Proc SQL – inner join        
• Section 4-03-02-Proc SQL – full join        
• Section 4-03-03-Proc SQL – left and right joins        
• Section 4-04-01-Proc SQL – creating macro vars 

• Section 5-00- Bonus lecture

• Unlimited access to the course for a lifetime.
• Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course.
• Structured lesson planning in line with industry standards.
• Immerse yourself in innovative and captivating course materials and activities.
• Assessments designed to evaluate advanced cognitive abilities and skill proficiency.
• Flexibility to complete the Course at your own pace, on your own schedule.
• Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.
• Unlock career resources for CV improvement, interview readiness, and job success.

• Data enthusiasts seeking to enhance their SAS programming skills.
• Business analysts aiming to leverage SAS for more effective data analysis.
• IT professionals aspiring to streamline data management through SAS.