We are the Information Technology training division of Aspire Techsoft Pvt Ltd, an IT company founded in 2011.We are ranked among the software training institutes in the india. We are specialized in ERP, SAP, SAS, JAVA, Data Warehousing,Hadoop etc.

Kothrud Branch (Head Office)
  • Address: Malhar Building, Plot No 2, H. A. Colony,
    Paud Phata, Eardawana, Pune 38.
  • Phone:7058-198-728 / 7058-733-423
  • Email:info@aspireit.net
Dange Chowk Branch
  • Address: Office No 108, 1st Floor, ABC Nirman Complex,
    Opp Macdonald, 16 No Stop, Near Dange Chowk, Pimpri Chinchwad, Pune - 33.
  • Phone:8856-033-664
  • Email:aspiretech.erpsolution@gmail.com

Advance SAS

  • PROC SQL Basics

  • Writing a PROC SQL Step

  • Selecting Columns

  • Specifying the Table

  • Specifying Sub setting Criteria

  • Ordering Rows

  • Querying Multiple Tables

  • Summarizing Groups of Data

  • Creating Output Tables

  • Viewing SELECT Statement Syntax
  • Displaying All Columns
  • Limiting the Number of Rows Displayed
  • Eliminating Duplicate Rows from Output
  • Sub setting Rows by Using Conditional Operators
  • Sub setting Rows by Using Calculated Values
  • Enhancing Query Output
  • Summarizing and Grouping Data
  • Sub setting Data by Using Sub queries
  • Sub setting Data by Using No correlated Sub queries
  • Sub setting Data by Using Correlated Sub queries
  • Understanding Joins

  • Generating a Cartesian product

  • Using Inner Joins

  • Using Outer Joins

  • Creating an Inner Join with Outer Join-Style Syntax
  • Comparing SQL Joins and DATA Step Match-Merges
  • Restricting data set size by selecting variables with DROP= and KEEP=
  • Using In-Line Views
  • Joining Multiple Tables and Views
  • Understanding Set Operations
  • Using the EXCEPT Set Operator
  • Using the INTERSECT Set Operator
  • Using the UNION Set Operator
  • Using the OUTER UNION Set Operator
  • Comparing Outer Unions and Other SAS Techniques
  • Understanding Methods of Creating Tables
  • Creating an Empty Table by Defining Columns
  • Displaying the Structure of a Table
  • Creating an Empty Table That Is Like another Table
  • Creating a Table from a Query Result
  • Inserting Rows of Data into a Table
  • Creating a Table That Has Integrity Constraints
  • Handling Errors in Row Insertions
  • Displaying Integrity Constraints for a Table
  • Comparing methods of merging (joining) data sets
  • Updating Values in Existing Table Rows
  • Deleting Rows in a Table
  • Altering Columns in a Table
  • Dropping Tables
  • Understanding Indexes
  • Deciding Whether to Create an Index
  • Creating an Index
  • Displaying Index Specifications
  • Managing Index Usage
  • Dropping Indexes
  • Creating and Using PROC SQL Views
  • Displaying the Definition for a PROC SQL View
  • Managing PROC SQL Views
  • Updating PROC SQL Views
  • Dropping PROC SQL Views
  • Specifying SQL Options
  • Controlling Execution
  • Controlling Output
  • Testing and Evaluating Performance Resetting Options
  • Using Dictionary Tables
  • Basic Concepts
  • Using Automatic Macro Variables
  • Using User-Defined Macro Variables
  • Processing Macro Variables
  • Displaying Macro Variable Values in the SAS Log
  • Using Macro Functions to Mask Special Characters
  • Using Macro Functions to Manipulate Character Strings
  • Using SAS Functions with Macro Variables
  • Combining Macro Variable References with Text
  • Creating a Macro Variable during DATA Step Execution
  • Creating Multiple Macro Variables during DATA Step Execution
  • Referencing Macro Variables Indirectly
  • Obtaining Macro Variable Values during DATA Step Execution
  • Creating Macro Variables during PROC SQL Step Execution
  • Working with PROC SQL Views
  • Using Macro Variables in SCL Programs
  • Basic Concepts
  • Developing and Debugging Macros
  • Using Macro Parameters
  • Understanding Symbol Tables
  • Processing Statements Conditionally
  • Processing Statements Iteratively
  • Using Arithmetic and Logical Express
  • Understanding Session-Compiled Macros
  • Storing Macro Definitions in External Files
  • Storing Macro Definitions in Catalog SOURCE Entries
  • Using the Auto call Facility
  • Using Stored Compiled Macros

Download PDF

Benefits of Aspire Techsoft training

ASAP methodology







sachin phate

  • 2018-02-16

best in pune. thank you aspire


Juhi Gujarathi

  • 2017-06-19

Aspire has provided both practical and theoretical training,staff was cooperative,faculty was highly experienced in SAS, good training i have got from ASpir


Aashay wasnik

  • 2016-12-24

I did SAS course from Aspire. it was a good learning experience.

Did Aspire convinced you ? Add Your Review

Your Ratings

Courses We Offer


Explore Smarty