click to enable zoom
Loading Maps
We didn't find any results
View Roadmap Satellite Hybrid Terrain My Location Fullscreen Prev Next
Advanced Search

₹ 0 to ₹ 100,000

We found 0 results. Do you want to load the results now ?
Advanced Search

₹ 0 to ₹ 100,000

we found 0 results
Your search results

Advance SAS Programming Course Online at Professional Sas Tutor

#703, 30th Main, 1st Phase, 2nd Stage,
add to favorites

About The Course:-

Best SAS Online Training Institute. We provide online SAS training with Real-time, Experienced Faculties for Individuals and Corporates.

Who Should Take this?

Systems administrators, linux administrators, windows administrators, Infrastructure engineers, Big Data Architects, DB Administrators, IT managers and Mainframe Professionals.

Pre-requisites for this training
This course requires  prior knowledge of Java

Course Objectives

    • 1. Introduction
      • 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

      SAS Macro Language


      1. Introduction

      • Getting Familiar to the macro facility

      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


      Advanced SAS Programming Techniques

      • 1. Measuring Efficiencies
        • Measuring efficiency

        2. 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

        3. Accessing Observations

        • Creating a sample data set
        • Creating an index
        • Using an index

        4. Using DATA Step Arrays

        • Introduction to lookup techniques
        • Using one-dimensional arrays
        • Using multidimensional arrays
        • Loading a multidimensional array from a SAS data set

        5. 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

        6. Combining Data Horizontally

        • DATA step merges and SQL procedure joins
        • Using an index to combine data
        • Combining summary and detail data
        • Combining data conditionally

        7. Expert Programmer Techniques

        • Creating user-defined functions
        • The experts’ FORMAT procedure
Good Course
  • Content
  • Instructor
  • Institute
User Rating 0 (0 votes)
Comments Rating 0 (0 reviews)
Start-End Dates: Contact Institute
Instructional Level: Appropriate for All
Live Projects
Doubt Clearing Sessions
Reading Material
EMI Option
Online Support
Post completion course access
Practice Exams
Placement assistance
Refund Policy
Post completion support

Compare courses

Leave a Reply

Contact Us