Call:(+91) 8218653603

 (+91) 8218653603

Email:info@yamiservices.com

  • Sign In
  • |
  • Sign Up
meta title

Related Courses

ADVANCE SAS

Join With Our Courses To Develop Yourself.

$75
10.jpg

Courses Overview

Advance SAS (Statistical Analysis System) training enables you to explore the depth and width of SAS knowledge. The Knowledge of Advance SAS takes you to the higher level of data analysis helping enterprises in taking advantage of business intelligence. This business analyst course is divided into three sections, namely

  • SAS SQL 1: Essentials
  • SAS Macro Language 2: Essentials
  • SAS Programming 3: Advanced Techniques and Efficiencies

SAS SQL 1: Essentials

1. Introduction

Ø  Overview of SAS Foundation

Ø  Course logistics

Ø  Course data files

Ø  Introducing the Structured Query Language

2. Basic Queries

Ø  Overview of the SQL procedure

Ø  Specifying columns

Ø  Specifying rows

3. Displaying Query Results

Ø  Presenting data

Ø  Summarizing data

4. SQL Joins

Ø  Introduction to SQL joins

Ø  Inner joins

Ø  Outer joins

Ø  Complex SQL joins

5. Subqueries

Ø  Noncorrelated subqueries

Ø  In-line views

6. Set Operators

Ø  Introduction to set operators

Ø  UNION operator

Ø  OUTER UNION operator

Ø  EXCEPT operator

Ø  INTERSECT operator

7. Creating Tables and Views

Ø  Creating tables with the SQL procedure

Ø  Creating views with the SQL procedure

8. Advanced PROC SQL Features

Ø  Dictionary tables and views

Ø  Using SQL procedure options

Ø  Interfacing PROC SQL with the macro language

9. Learning More

Ø  SAS resources

Ø  Beyond this course

10. Self-Study Topics

Ø  Correlated subqueries

Ø  Introduction to indexes

Ø  Creating indexes

Ø  Maintaining tables with the SQL procedure

Ø  Integrity constraints

Ø  Creating and using macro variables in PROC SQL

SAS Macro Language 2: Essentials

Ø  Introduction

Ø  Overview of SAS Foundation

Ø  Course logistics

Ø  Purpose of the macro facility

Ø  Program flow

2. Macro Variables

Ø  Introduction to macro variables

Ø  Automatic macro variables

Ø  Macro variable references

Ø  User-defined macro variables

Ø  Delimiting macro variable references

Ø  Macro functions

3. Macro Definitions

Ø  Defining and calling a macro

Ø  Macro parameters

4. DATA Step and SQL Interfaces

Ø  Creating macro variables in the DATA step

Ø  Indirect references to macro variables

Ø  Creating macro variables in SQL

5. Macro Programs

Ø  Conditional processing

Ø  Parameter validation

Ø  Iterative processing

Ø  Global and local symbol tables

6. Learning More

Ø  SAS resources

Ø  Beyond this course

7. Supplemental Materials

Ø  Program flow

SAS Programming 3: Advanced Techniques and Efficiencies

1. Introduction

Ø  Overview of SAS Foundation

Ø  Course logistics

Ø  Creating the course data

2. Measuring Efficiencies

Ø  Measuring efficiencies

3. Controlling I/O Processing and Memory

Ø  SAS DATA step processing

Ø  Controlling I/O

Ø  Using SAS views

Ø  Reducing the length of numeric variables

Ø  Compressing SAS data sets

4. Accessing Observations

Ø  Creating a sample data set

Ø  Creating an index

Ø  Using an index

 

5. Using DATA Step Arrays

Ø  Introduction to lookup techniques

Ø  Using one-dimensional arrays

Ø  Using multidimensional arrays

Ø  Loading a multidimensional array from a SAS data set

6. Using DATA Step Hash and Hiter Objects

Ø  Introduction

Ø  Using hash object methods

Ø  Loading a hash object with data from a SAS data set

Ø  Using the DATA step hiter object

7. Combining Data Horizontally

Ø  DATA step merges and SQL procedure joins

Ø  Using an index to combine data

Ø  Combining summary and detail data

Ø  Combining data conditionally

8. Expert Programmer Techniques

Ø  Creating user-defined functions

Ø  The experts' FORMAT procedure

9. Learning More

Ø  Introduction

  • Duration: 40 Days
  • Services

    Technical Support Project, Consultancy Monitoring and Control Smart Metering Data Logging, Dedicated Graphical Interface


    Corporate Training, Industrial Training, Campus Training, Classroom Training, Bootcamp Training, Online Training


    Data Science, Machine Learning, Robotics, Business Intelligance, Finance Controlling, Water Treatment and Power Plants


    Domestic Tech. / Non Tech. and International - Tech. only


    ADDITIONAL SERVICES


    ISO 9001-1015 Yami Cosmo Services Pvt. Ltd Copyright© 2017. TeghDeveloperTechnlogies All right reserved.