SAS /
SAS Base and Advanced

SAS Base and Advanced

SAS Base and Advanced Online Training:

Who is Eligible:

Any Graduates/Post Graduates are eligible.
Any Functional/technical background consultants are eligible to learn SAS Base and Advanced Online Training.

  • 1

    Use Formatted, List and Column input to read raw data files.

    00:00
  • 2

    Use INFILE statement options to control processing when reading raw data files

    00:00
  • 3

    Use various components of an INPUT statement to process raw data files including
    column and line pointer controls

    00:00
  • 5

    Combine SAS data sets using the DATA step

    00:00
  • 1

    Create temporary and permanent SAS data sets

    00:00
  • 2

    Create and manipulate SAS date values

    00:00
  • 3

    Use DATA Step statements to export data to standard and comma delimited raw data files

    00:00
  • 4

    Control which observations and variables in a SAS data set are processed and output

    00:00
  • 1

    Investigate SAS data libraries using base SAS utility procedures

    00:00
  • 2

    Sort observations in a SAS data set

    00:00
  • 3

    Conditionally execute SAS statements

    00:00
  • 4

    Use assignment statements in the DATA step

    00:00
  • 5

    Modify variable attributes using options and statements in the DATA step

    00:00
  • 6

    Accumulate sub-totals and totals using DATA step statements

    00:00
  • 7

    Use SAS functions to manipulate character data, numeric data,and SAS date values

    00:00
  • 8

    Use SAS functions to convert character data to numeric and vice versa

    00:00
  • 9

    Process data using DO LOOPS

    00:00
  • 10

    Process data using SAS arrays

    00:00
  • 1

    Generate list reports using the PRINT and REPORT procedures

    00:00
  • 2

    Generate summary reports and frequency tables using base SAS procedures

    00:00
  • 3

    Enhance Reports Through The Use Of Labels

    00:00
  • 8

    Sas System Reporting Options

    00:00
  • 9

    Generate HTML reports using ODS statements

    00:00
  • 1

    Identify and resolve programming logic errors

    00:00
  • 2

    Recognize and correct syntax errors

    00:00
  • 3

    Examine and resolve data errors

    00:00
  • 2

    Generate detail reports by working with a single table or joining tables using
    PROC SQL and the appropriate options

    00:00
  • 3

    Generate summary reports by working with a single table or joining tables using
    PROC SQL and the appropriate options

    00:00
  • 4

    Construct subqueries within a PROC SQL step

    00:00
  • 5

    Compare solving a problem using the SQL procedure versus using traditional SAS
    programming techniques

    00:00
  • 6

    Access Dictionary Tables using the SQL procedure

    00:00
  • 7

    Demonstrate advanced PROC SQL skills by creating and updating tables

    00:00
  • 8

    Use Proc Datasets To Demonstrate Advanced Programming Skills (Updating Data Values)

    00:00
  • 9

    Working With Indexes Using The Macro Interface/Creating Macro Variables With Sql

    00:00
  • 10

    Defining Integrity Constraints

    00:00
  • 11

    Sql Views And Set Operators

    00:00
  • 1

    Creating and using user-defined and automatic macro variables within the SAS
    Macro Language

    00:00
  • 2

    Automate programs by defining and calling macros using the SAS Macro Language

    00:00
  • 3

    Understand the use of macro functions

    00:00
  • 4

    Recognize various system options that are available for macro debugging and
    displaying values of user-defined and automatic macro variables in the SAS log

    00:00
  • 1

    Demonstrate Advanced Data Set Processing Techniques Such As Updating Master Data Sets

    00:00
  • 4

    Sampling Data Using Generation Data Sets

    00:00
  • 5

    Integrity Constraints And Audit Trails

    00:00
  • 6

    Reduce The Space Required To Store Sas Data Sets And Numeric Variables Within Sas
    Data Sets By Using Compression Techniques

    00:00
  • 7

    Length Statements Or Data Step Views

    00:00
  • 8

    Develop efficient programs by using advanced programming techniques such as permanent
    formats and array processing

    00:00
  • 1

    Control the processing of variables and observations in the DATA step

    00:00
  • 2

    Create Sorted Or Indexed Data In Order To Avoid Unnecessary Sorts

    00:00
  • 3

    Eliminate Duplicate Data And To Provide More Efficient Data Access And Retrieval

    00:00
  • 4

    Use PROC DATASETS to demonstrate advanced programming skills
    (e.g. renaming columns, displaying metadata, creating indexes, creating integrity
    constraints, creating audit trails)

    00:00
NA