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
717

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
4.7
User Rating 0 (0 votes)
Sending
Comments Rating 0 (0 reviews)
Start-End Dates: Contact Institute
Instructional Level: Appropriate for All
Certification
Quizzes
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