Description

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this step-by-step Advanced SAS Programming Using MacrosSQL training course. This Advanced SAS Programming Using MacrosSQL course for Consistent Profits has been specially designed to help learners gain a good command of Advanced SAS Programming Using MacrosSQL, providing them with a solid foundation of knowledge to understand relevant professionals' job roles.

Through this Advanced SAS Programming Using MacrosSQL course, you will gain a theoretical understanding of Advanced SAS Programming Using MacrosSQL and others relevant subjects that will increase your employability in this field, help you stand out from the competition, and boost your earning potential in no time.

Not only that, but this Advanced SAS Programming Using MacrosSQL training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry.

This course is fully CPD-accredited and broken down into several manageable modules, making it ideal for aspiring professionals.

Learning outcome

Familiar yourself with the recent development and updates of the relevant industry

Know how to use your theoretical knowledge to adapt in any working environment

Get help from our expert tutors anytime you need

Access to course contents that are designed and prepared by industry professionals

Study at your convenient time and from wherever you want

Why should I take this course?

Affordable premium-quality E-learning content, you can learn at your own pace.

You will receive a completion certificate upon completing the course.

Internationally recognized Accredited Qualification will boost up your resume.

You will learn the researched and proven approach adopted by successful people to transform their careers.

You will be able to incorporate various techniques successfully and understand your customers better.

Requirements

No formal qualifications required, anyone from any academic background can take this course.

Access to a computer or digital device with internet connectivity.

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 - Advanced SAS Programming Using MacrosSQL	🕐 00:00:00

Course Images

Advanced SAS Programming Using MacrosSQL

By Skill Up

Booking options

Highlights

Description

About The Provider

Tags

Reviews