SAS /
SAS VBA Microsoft Excel

SAS VBA Microsoft Excel

SAS VBA Microsoft Excel Online Training:

Who is Eligible:

Any Graduates/Post Graduates are eligible.
Any Functional/technical background consultants are eligible to learn SAS VBA Microsoft Excel Online Training.

  • 1

    Accessing data that is stored in a SAS data set is a fundamental operation in SAS

    00:00
  • 2

    Accessing data from FLAT files

    00:00
  • 3

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

    00:00
  • 4

    Use various components of an INPUT statement to process raw data files

    00:00
  • 5

    including column and line pointer controls and trailing @ controls

    00:00
  • 6

    Accessing data from a Database

    00:00
  • 8

    Accessing data from existing SAS dataset

    00:00
  • 1

    Create temporary and permanent SAS data sets

    00:00
  • 3

    Understanding How Data Sets Are Read

    00:00
  • 4

    Export data to create standard and comma-delimited raw data files

    00:00
  • 5

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

    00:00
  • 1

    Learn, different types of SAS Functions

    00:00
  • 2

    Investigate SAS data libraries using base SAS utility procedures

    00:00
  • 3

    Sort observations in a SAS data set, 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

    00:00
  • 8

    Process data using DO LOOPS and Process data using SAS arraysValidate and clean data

    00:00
  • 1

    This module focus you on how to Generate reports and listing up reports using PRINT procedure

    00:00
  • 2

    Generate list reports using the PRINT procedure

    00:00
  • 3

    Generate summary reports and frequency tables using base SAS procedures

    00:00
  • 4

    Enhance reports through the use of user-defined formats, titles, footnotes and SAS System reporting

    00:00
  • 5

    Generate reports using ODS statements

    00:00
  • 1

    Error handling refers to the anticipation, detection, and resolution of programming, application, and communications errors

    00:00
  • 2

    Identify and resolve programming logic errors

    00:00
  • 3

    Recognize and correct syntax errors

    00:00
  • 4

    Examine and resolve data errors

    00:00
  • 1

    Using SQL, SAS users can create SAS datasets from, and manage the data contained in, relational databases

    00:00
  • 2

    Generate detail reports by working with a single table, joining tables or using set operators in the SQL procedure

    00:00
  • 3

    Generate summary reports by working with a single table, joining tables or using set operators in the SQL procedure

    00:00
  • 4

    Construct sub-queries and in-line views within an SQL procedure 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
  • 1

    This section describes macro processing and shows the typical pattern that SAS follows to process a program containing macro elements

    00:00
  • 2

    Create and use user-defined and automatic macro variables within the SAS Macro Language

    00:00
  • 3

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

    00:00
  • 4

    Understand the use of macro functions

    00:00
  • 5

    Use 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
  • 6

    Create data-driven programs using SAS Macro Language

    00:00
NA