Advanced SAS Programming Using MacrosSQL
Learning Outcome
- Master Advanced SAS in the most effective way through simple, visual and engaging lectures
- Learn to analyze data with powerful SAS procedures that reveal amazing insights within your data
- Understand how to build powerful SAS Macros
- Get the opportunity to strengthen your foundation to appear for SAS Advanced certification exams
- Get a grip on how to use the combined power of SAS and SQL in Proc SQL
Description
The Advanced SAS Programming Using MacrosSQL is the best way for you to gain deep insight and knowledge of this topic. You will learn from industry experts and obtain an accredited certificate after completing the course. Enrol now for a limited-time discounted price.
Like all the courses of Thames College, this Advanced SAS Programming Using MacrosSQL is designed with the utmost attention and thorough research. All the topics are broken down into easy to understand bite-sized modules that help our learners to understand each lesson very easily.
We don’t just provide courses at Thames College; we provide a rich learning experience. After purchasing a course from Thames College, you get complete 1-year access with tutor support.
Our expert instructors are always available to answer all your questions and make your learning experience exquisite.
After completing the Advanced SAS Programming Using MacrosSQL, you will instantly get an e-certificate that will help you get jobs in the relevant field and will enrich your CV.
If you want to learn about this topic and achieve certifications, you should consider this Advanced SAS Programming Using MacrosSQL from Thames College.
There are no hidden fees or exam charges. We are very upfront and clear about all the costs of the course.
Course design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
Will I receive a certificate of completion?
Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hard Copy Certificate for £15.
Why study this course
Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.
The Advanced SAS Programming Using MacrosSQL is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
Course Curriculum
| Advanced SAS Programming Using MacrosSQL | |||
| Unit - 1 | |||
| Section 0-00- Why SAS | 00:01:00 | ||
| Unit - 2 | |||
| Section 2-02- SAS Studio through SAS OnDemand- Registration | 00:04:00 | ||
| Section 2-03- Logging-in to SAS after installation | 00:01:00 | ||
| Section 2-04- SAS Interface and windows | 00:06:00 | ||
| Unit - 3 | |||
| Section 3-00- Section Overview – Macros | 00:01:00 | ||
| Section 3-01-Macro Variables – introduction | 00:14:00 | ||
| Section 3-02-Application of macro variables | 00:13:00 | ||
| Section 3-03-01-Nested macro vars | 00:11:00 | ||
| Section 3-03-02-More on Ampersand resolutions using a cool example | 00:09:00 | ||
| Section 3-04-00-SAS Macros – introduction | 00:10:00 | ||
| Section 3-04-01-SAS Macros – Examples | 00:07:00 | ||
| Section 3-04-02-Keyword positional and mixed params | 00:06:00 | ||
| Section 3-04-03-Conditional Logic in Macros | 00:11:00 | ||
| Section 3-05-Macro Functions | 00:12:00 | ||
| Section 3-05-Options Statement- mprint-mlogic-symbolgen | 00:13:00 | ||
| Section 3-07-Connecting the two worlds – Call Symput – Symget | 00:14:00 | ||
| Section 3-09-01-02- Bringing data into SAS using Import Wizard | 00:04:00 | ||
| Section 3-09-02- Bringing data into SAS using LIBNAME statement | 00:05:00 | ||
| Section 3-09-03- Bringing data into SAS using FILENAME | 00:05:00 | ||
| Unit - 4 | |||
| Section 4-00- Section Overview – Proc SQL | 00:01:00 | ||
| Section 4-01-01-Proc SQL – copying data | 00:13:00 | ||
| Section 4-01-02-Proc SQL – filtering data | 00:07:00 | ||
| Section 4-01-03-Proc SQL – sorting data | 00:08:00 | ||
| Section 4-01-04-Proc SQL – removing duplicates | 00:05:00 | ||
| Section 4-02-01-Proc SQL – Union | 00:09:00 | ||
| Section 4-02-02-Proc SQL – Except | 00:04:00 | ||
| Section 4-02-03-Proc SQL – Intersect | 00:02:00 | ||
| Section 4-03-00-Merging data using Joins-Introduction | 00:08:00 | ||
| Section 4-03-01-Proc SQL – inner join | 00:14:00 | ||
| Section 4-03-02-Proc SQL – full join | 00:08:00 | ||
| Section 4-03-03-Proc SQL – left and right joins | 00:07:00 | ||
| Section 4-04-01-Proc SQL – creating macro vars | 00:07:00 | ||
| Unit - 5 | |||
| Section 5-00- Bonus lecture | 00:02:00 | ||
| Resources | |||
| Resources – Advanced SAS Programming Using MacrosSQL | 00:00:00 | ||
| Assignment | |||
| Assignment -IT Professional 2.0 Take Your Career To The Next Level | 05:00:00 | ||
Certificate of Achievement
Upon completion, you will receive a CPD-accredited certificate recognised globally. Choose from:
Pdf Certificate & Transcript £7.99
Hardcopy Certificate & Transcript £17.99
This certification validates your knowledge and skills, boosting your employability in healthcare.
Course Reviews
No Reviews found for this course.
Get Upto 95% OFF
Offer Ends Soon
Access
Level
Number of Units
Number of Quizzes
Duration