Return to Workshops;    SAS Page;    Home.
SAS Work Shop Statistical Programs   
DATA STEP College of Agriculture
Outline http://www.uidaho.edu/ag/statprog

  1. GENERAL CONSIDERATIONS
    1. Environment
      1. Modes of Operation
        1. Interactive
          1. SAS - Windowed
        2. Non-Interactive (Batch)
          1. SAS fn (Output Files)
          2. Requires Editor (Write, Execute, & Examine)
    2. SAS Program Structure
      1. Types of Blocks
        1. DATA Steps
        2. PROC Steps
      2. Path of Execution
        1. Scan Statements
        2. Delimit Blocks (Key Words)
        3. Execute Blocks Sequentially (Any Number, Any order)
      3. Writing Programs to Reflect SAS Structure
        1. Separation of Blocks
        2. Indentation within Blocks
        3. Use of Comments (Human Factor)
        4. Use of Capitalization
  2. DATA STEP
    1. Description of a SAS Data Set
      1. What is in a Data Set
      2. Difference Between a Data Set and a Data File
    2. Getting Data In
      1. Input Statement
        1. List (Free Field) Input
        2. lumn Input
        3. Formatted Input (Pointers)
        4. Mixed Input
        5. Importance of Missing Values
      2. Data Control Vector (DCV)
        1. Status During Data Step Iterations
        2. Maintaining Rectangular Shape (Missing Values)
      3. Where Data Sets Come From (Sources)
        1. Internal Data (Cards)
        2. External Data (Infile, Import)
        3. Other Datasets
          1. SET Statement
          2. MERGE Statement
        4. PROC's
          1. OUTPUT Statement
    3. Manipulation of Data (Programming)
      1. IF Statements
        1. Subsetting IF with Retention
        2. Subsetting IF with Deletion
        3. IF - THEN - ELSE (Efficiency)
      2. DO - END Statements
        1. DO Groups (Multiple Statements)
        2. DO Loops (Iterative Calculations)
          1. Use of the ARRAY Statement
      3. Controlling Output
        1. Implied Output
        2. Explicit Output (OUTPUT Statement)
        3. Data Set Options (KEEP, DROP, RENAME)
      4. SAS Functions and Operators
        1. Handling of Missing Values
        2. Examples of SAS Operators & Functions
    4. Getting Data Out
      1. Permanent Datasets
        1. Libraries
        2. Datasets and Members
      2. Exporting ASCII Files
        1. FILE Statement
        2. PUT Statement
      3. Exporting Other Data Types