Advance SAS Course

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

  • 24 HOURS LAB

  • MATERIAL SOFT COPY& HARD COPY

  • 100% PLACEMENT ASSISTANCE

  • RESUME PREPARATION

  • SOFT SKILLS& HR TIPS

  • PERSONALITY DEVELOPMENT

  • MOCK INTERVIEWS

Reviews

  • Aashay wasnik

    2016-12-24

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

    • 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

    Your Rating :

53618 Students applied

100 Comments

  • John Doe

    Morbi nec nisi ante. Quisque lacus ligula, iaculis in elit et, interdum semper quam. Fusce in interdum tortor. Ut sollicitudin lectus dolor eget imperdiet libero pulvinar sit amet

    • John Doe

      Morbi nec nisi ante. Quisque lacus ligula, iaculis in elit et, interdum semper quam. Fusce in interdum tortor. Ut sollicitudin lectus dolor eget imperdiet libero pulvinar sit amet

    • John Doe

      Morbi nec nisi ante. Quisque lacus ligula, iaculis in elit et, interdum semper quam. Fusce in interdum tortor. Ut sollicitudin lectus dolor eget imperdiet libero pulvinar sit amet

  • John Doe

    Morbi nec nisi ante. Quisque lacus ligula, iaculis in elit et, interdum semper quam. Fusce in interdum tortor. Ut sollicitudin lectus dolor eget imperdiet libero pulvinar sit amet

  • John Doe

    Morbi nec nisi ante. Quisque lacus ligula, iaculis in elit et, interdum semper quam. Fusce in interdum tortor. Ut sollicitudin lectus dolor eget imperdiet libero pulvinar sit amet

  • John Doe

    Morbi nec nisi ante. Quisque lacus ligula, iaculis in elit et, interdum semper quam. Fusce in interdum tortor. Ut sollicitudin lectus dolor eget imperdiet libero pulvinar sit amet

  • 1Register
  • 2Order and payment
  • 3Finish checkout

sign in

Forget password?

New Member

Choose your payment method

Total Payment

$89

Thank You For Your Purchase

Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci.

Share

We Are Offering This Courses