Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - SAS Programming II: Data Management - DATA Step

Home

distance-learning center

Computer-Device_Tethered-Distance-learning Distance-learning-Building

Professional Distance-learning

IT Training Services



MFSYS74

SAS Programming II: Data Management - DATA Step
DURATION: 3 days

FEE: $1,275

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • Business Professional
  • Statistician
  • Report Designer
  • Programmer
  • IT Professional
 
   

DATES:

CONTENT AND OBJECTIVES:
    1. Introduction
      • Code a program which uses dataset processing in multiple steps.
    2. Controlling Input and Output
      • Output multiple observations and write to multiple SAS datasets.
    3. Summarizing Data
      • Accumulating totals and accumulating variable by coding the logic without a PROC.
    4. Reading and Writing Different Types of Data
      • z/OS: Read a VSAM dataset into a SAS dataset.
      • MS Windows: Read an Excel spreadsheet into a SAS dataset.
      • z/OS or MS Windows: Read a DB2 table into a SAS dataset.
      • Reading hierarchical raw data files.
    5. Data Transformations
      • Manually reformat SSN, phone numbers, and dates using character manipulation.
      • Convert numeric, dates, and character fields.
    6. Processing Data Iteratively
      • Store data into a two-dimensional table and traverse the table.
    7. Combining SAS Datasets
      • Match-merge two SAS datasets and print out frequency statistics.
      • Optional: Join two tables in Db2 and print out frequency statistics.

 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
 

 

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.