SAS /
SAS Foundation Advanced

SAS Foundation Advanced

SAS Foundation Advanced Online Training:

Who is Eligible:

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

  • 3

    Industries Covered by SAS

    00:00
  • 4

    Modules/Applications in SAS

    00:00
  • 5

    Ways to get data into SAS

    00:00
  • 1

    Windowing Environment of SAS

    00:00
  • 4

    SAS Data Sets and SAS Data Types

    00:00
  • 5

    Introduction to SAS Enterprise Guide

    00:00
  • 6

    A Simple Program with Report output

    00:00
  • 7

    More on Comment Statements

    00:00
  • 8

    Data Step compile and execution

    00:00
  • 1

    Reading Data Values Separated by Blanks and Commas

    00:00
  • 2

    Reading Data Values Separated by other Delimiters

    00:00
  • 3

    Placing Data Lines Directly in Your Program

    00:00
  • 4

    Reading Raw Data from Fixed Columns - Column Input method

    00:00
  • 5

    Reading Raw Data from Fixed Columns - Formatted Input method

    00:00
  • 6

    Reading Raw Data Mixed Input method

    00:00
  • 7

    FORMAT Statement in DATA versus PROC Steps

    00:00
  • 8

    INFORMAT Statement with List Input

    00:00
  • 9

    List Input with Embedded Delimiters

    00:00
  • 1

    Detecting the End of the File

    00:00
  • 2

    Reading a Portion of a Raw Data File

    00:00
  • 3

    Reading Data from Multiple Files

    00:00
  • 4

    Reading Data from Multiple Files Using a FILENAME Statement

    00:00
  • 5

    Reading External Filenames from a Data File

    00:00
  • 6

    Reading Data Conditionally (the Single Trailing @ Sign)

    00:00
  • 7

    More Examples of the Single Trailing @ Sign

    00:00
  • 8

    Using Relative Column Pointers to Read a Complex Data Structure Efficiently

    00:00
  • 1

    SAS Libraries the LIBNAME Statement

    00:00
  • 2

    Examining the Descriptor Portion of a SAS Data Set

    00:00
  • 3

    Listing All the SAS Data Sets in a SAS Library

    00:00
  • 4

    SAS Data Set as Input to a DATA Step

    00:00
  • 5

    DATA _NULL_: A Data Set That Isn't

    00:00
  • 2

    Formats to Enhance Your Output

    00:00
  • 3

    Regrouping Values Using Formats

    00:00
  • 4

    Permanent Data Set Attributes

    00:00
  • 1

    To import data from different PC files use import procedure

    00:00
  • 2

    To export data from different source use access procedure

    00:00
  • 3

    To export data from datasets to different PC files use export Procedures

    00:00
  • 4

    Uses of DB Load procedure and how to work

    00:00
  • 5

    To transport datasets one environment to another environment and one version to another version to another version (windows to UNIX) use with cprot and cimport procedures

    00:00
  • 6

    How to use Upload Procedure

    00:00
  • 7

    How to use Download Procedure

    00:00
  • 1

    The IF and ELSE IF Statements

    00:00
  • 2

    The Sub setting IF Statement

    00:00
  • 4

    SELECT Statement for Logical Tests

    00:00
  • 5

    Boolean Logic (AND, OR, and NOT Operators)

    00:00
  • 4

    Other Forms of an Iterative DO Loop

    00:00
  • 5

    DO WHILE and DO UNTIL Statements

    00:00
  • 2

    Computing the Number of Years between Two Dates

    00:00
  • 3

    Demonstrating a Date Constant

    00:00
  • 4

    Extracting the Day of the Week, Day of the Month, Month, and Year

    00:00
  • 5

    Creating a SAS Date from Month, Day, and Year Values

    00:00
  • 1

    Sub setting a SAS Data Set

    00:00
  • 2

    Creating More Than One Subset Data Set in One DATA Step

    00:00
  • 3

    Adding Observations to a SAS Data Set

    00:00
  • 5

    Combining Detail and Summary Data

    00:00
  • 7

    Controlling Observations in a Merged Data Set

    00:00
  • 8

    More Uses for IN= Variables

    00:00
  • 1

    Functions That Round and Truncate Numeric Values

    00:00
  • 2

    Functions That Work with Missing Values

    00:00
  • 3

    Setting Character and Numeric Values to Missing

    00:00
  • 4

    Descriptive Statistics Functions

    00:00
  • 1

    Determining the Length of a Character Value

    00:00
  • 2

    Changing the Case of Characters

    00:00
  • 3

    Removing Characters from Strings

    00:00
  • 4

    Joining Two or More Strings Together

    00:00
  • 5

    Removing Leading or Trailing Blanks

    00:00
  • 6

    COMPRESS Function to Remove Characters from a String

    00:00
  • 10

    Substituting Characters or Words

    00:00
  • 1

    Setting Values of 999 to a SAS Missing Value for Several

    00:00
  • 3

    Setting Values of NA and? To a Missing Character Value

    00:00
  • 4

    Converting All Character Values to Lowercase

    00:00
  • 5

    Array to Create New Variables

    00:00
  • 6

    Changing the Array Bounds

    00:00
  • 1

    Displaying Your Data by PROC PRINT

    00:00
  • 2

    Organize and sort SAS data sets and working with duplicates by PROC SORT

    00:00
  • 3

    Comparing data sets with PROC COMPARE

    00:00
  • 4

    Using PROC COPY to copy data sets

    00:00
  • 5

    Using PROC DATASETS to modify data set structure, attributes

    00:00
  • 1

    Producing Statistical with means Procedure

    00:00
  • 2

    To summary statistical Analysis Summary Procedure

    00:00
  • 3

    Testing Categorical Data with FREQ PROCEDURE

    v0:00
  • 4

    Creating Customized Reports by PROC REPORT

    00:00
  • 5

    Creating Tabular Reports by PROC TABULATE

    00:00
  • 6

    Examining Data by PROC UNIVARATE

    00:00
  • 1

    Sending SAS Output to an HTML File

    00:00
  • 2

    Creating a Table of Contents

    00:00
  • 3

    Selecting a Different HTML Style

    00:00
  • 4

    Choosing Other ODS Destinations

    00:00
  • 5

    Selecting or Excluding Portions of SAS Output

    00:00
  • 6

    Sending Output to a SAS Data Set

    00:00
  • 1

    Producing Simple Bar Charts Using PROC GCHART

    00:00
  • 3

    Creating Bar Charts for a Continuous Variable

    00:00
  • 4

    Creating Charts with Values Representing Categories

    00:00
  • 5

    Creating Bar Charts Representing Means

    00:00
  • 6

    Adding another Variable to the Chart

    00:00
  • 1

    Using Formats to Recode Variables

    00:00
  • 2

    Using Formats with a PUT Function to Create New Variables

    00:00
  • 3

    Creating User-Defined Informats

    00:00
  • 4

    Reading Character and Numeric Data in One Step

    00:00
  • 5

    Using Formats (and Informats) to Perform Table Lookup

    00:00
  • 1

    Conversions of SAS Datasets with DATA step

    00:00
  • 2

    Conversions of SAS Datasets with PROC step

    00:00
  • 1

    Identifying the First or Last Observation in a Group

    00:00
  • 2

    Counting the Number of Visits Using PROC FREQ

    00:00
  • 3

    Counting the Number of Visits Using PROC MEANS

    00:00
  • 4

    Computing Differences between Observations

    00:00
  • 5

    Computing Differences between the First and Last Observation with BY Statement

    00:00
  • 1

    How the SAS macros Language Works

    00:00
  • 2

    Applying automatic macro variables

    v
  • 3

    Assigning Values to Macro Variables by various methods

    00:00
  • 4

    Resolving Macro variables during DATA STEP EXECUTION

    00:00
  • 2

    Cartesian Product and Joining concept

    00:00
  • 3

    Joining Two Tables (Merge)

    00:00
  • 4

    Left, Right, and Full Joins

    v
  • 6

    Set Operator us such as union and intersection joining multiple tables

    00:00
  • 7

    Using functions to summarize and group data

    00:00
  • 8

    Ordering data and formatting out

    00:00
  • 2

    Fixing Programs that don't work

    00:00
  • 3

    Searching for the missing semicolon

    00:00
  • 4

    Input statement reaching past the end of line

    00:00
  • 7

    How to handle different kind of SAS errors

    00:00
  • 8

    Missing VALUES were Generated

    00:00
  • 9

    Numeric values have been converted to Character

    00:00
  • 10

    WRONG results but no error message

    00:00
  • 2

    Finance/Banking/Insurance Domain

    00:00
NA