• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Advanced SAS Programming Using MacrosSQL

Advanced SAS Programming Using MacrosSQL

By Skill Up

4.8(9)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 4 hours 2 minutes

  • All levels

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

About The Provider

Skill Up
Skill Up
4.8(9)

Skill Up presents a rigorous online education experience, helping you obtain industry-relevant skills certified by the worldโ€™s...

Read more about Skill Up

Tags

Reviews