WHAT IS SAS and BASICS of SAS- 12HOURS

• History Of Sas
• Functionality Of Sas
• Architecture Of Sas
• Sas Program Rules
• File Elements Of Sas
• Sas Names & Rule
• Missing Data
• Types Of Variables
• How Sas System Read Values Into Variables
• Lengths of Variables
• Sas Windowing Environment
• Sas Program & Components Of Sas Program
• Creation Of Libraries
• Member Types
  • Datasets
  • Views
  • Catalogs
  • Indexes
• Sas Programming (Briefly)
  • Data Step
  • Proc Step
  • Global Options
  • Global Statements
• Backend Process Of SAS Program
• Installation Process
• ETL Concepts

BEGIN WITH DATASTEP - 10 HOURS

• Data Step & Purpose of Data Step
• Data Statement & Dataset Options
• Infile Statement & Options
• Input Statement & Types of Input & Options
• Datalines / Cards Statement (or) Datalines4 / Cards4 Statement
• Run Statement / Quit Statement

ATTRIBUTES OF VARIABLES - 8 HOURS

• Data Types
• Label Statement
• Length Statement
• Informat Statement
• Format Statement
• How Dates Works In Sas
• System Defined / User Defined Informats & Formats

OTHER SAS STATEMENTS - 5 HOURS

• Keep Statement
• Drop Statement
• Rename Statement
• Replace Statement
• Sum Statement
• Retain Statement
• Goto Statement
• Link Statement
• Return Statement
• Output Statement
• Stop Statement

CONDITIONAL STATEMENTS - 4 HOURS

• If Statement
• If Then Statement
• If Then Else Statement
• If Then Delete Statement
• If Then Remove Statement
• If Then Output Statement
• If Then Do Statement
• If Then Do While Statement
• If Then Do Until Statement
• If Then Goto Statement
• Where Statement
• Operators
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • Expressions

LOOPS - 5 HOURS

• Do Statement
• Do Iterative Statement
• Do While Statement
• Do Until Statement
• End Statement
• Output Statement
• Stop Statement