-
Cart
Registering for this site is easy. Just fill in the fields below, and we'll get a new account set up for you in no time.
Sign in to your One Education account
Advanced SAS Programming Using MacrosSQL
Advanced SAS Programming Using MacrosSQL
£29 ex Vat
Take This Course OR
1 Year Access 
Advanced
25 Students -
9 hours, 2 minutes
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 One Education, 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 One Education; we provide a rich learning experience. After purchasing a course from One Education, 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 One Education.
There are no hidden fees or exam charges. We are very upfront and clear about all the costs of the course.
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
Certification
After completing this course's assessment, you will be eligible for:
- A CPD QS accredited Certificate from One Education.
The CPD QS Accredited Certificate Is Available In PDF Format, At The Cost Of £9, Or A Hard Copy Can Be Sent To You Via Post, At The Cost Of £15.
Order Your Certificate here
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
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 | ||
Related Courses
Intermediate
Intermediate
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add