PROG79002
SAS Programming 3: Advanced Techniques and Efficiencies
Sheridan College Logo
 
  I: Administrative Information   II: Course Details   III: Topical Outline(s)  Printable Version
 
Section I: Administrative Information
  Total hours: 24.0
Credit Value: 0.0
Credit Value Notes: N/A
Effective: Fall 2018
Prerequisites: N/A
Corequisites: N/A
Equivalents: N/A

Pre/Co/Equiv Notes: N/A

Program(s): SAS Base Programming
Program Coordinator(s): N/A
Course Leader or Contact: N/A
Version:
20180904_00
Status: Approved (APPR)

Section I Notes: Students must bring a laptop with them to class.

 
 
Section II: Course Details

Detailed Description
This course is for SAS programmers who prepare data for analysis. Learn to compare manipulation techniques and resource cost benefits that are designed to help programmers choose the most appropriate technique for their data situation. You will also learn how to compare various SAS programming techniques to make informed decisions.

Program Context

 
SAS Base Programming Program Coordinator(s): N/A
This is course will prepare you for the SAS Certified Advanced Programmer.


Course Critical Performance and Learning Outcomes

  Critical Performance:
Students will have demonstrate the ability to prepare data for analysis using manipulation and cost benefits techniques.
 
Learning Outcomes:

To achieve the critical performance, students will have demonstrated the ability to:

  1. Benchmark computer resource usage
  2. Control memory, I/O, and CPU resources
  3. Create and use indexes
  4. Combine data horizontally
  5. Use hash and hiter DATA step component objects and arrays as lookup tables
  6. Compress SAS data sets
  7. Sample your SAS data sets
  8. Create and use SAS data views
  9. Safely reduce the length of numeric variables
  10. Create user-defined functions and informats.

Evaluation Plan
Students demonstrate their learning in the following ways:

 Evaluation Plan: IN-CLASS
 In-Class Assignments/Quizzes100.0%
Total100.0%

Provincial Context
The course meets the following Ministry of Training, Colleges and Universities requirements:

 

Prior Learning Assessment and Recognition
PLAR Contact (if course is PLAR-eligible) - Office of the Registrar

  • Not Eligible for PLAR

 
 
Section III: Topical Outline
Some details of this outline may change as a result of circumstances such as weather cancellations, College and student activities, and class timetabling.
Instruction Mode: In-Class
Professor: Multiple Professors
Resource(s): N/A
Applicable student group(s): Continuing and Professional Studies Students.
Course Details:

Introduction

  • Course logistics
  • Creating course data files

Efficient SAS Programming

  • Identifying computer resources related to efficiency

Controlling I/O Processing and Memory

  • SAS DATA step processing
  • Controlling I/O
  • Reducing the length of numeric variables
  • Compressing SAS data sets
  • Using SAS views

Accessing Observations

  • Access methods
  • Accessing observations by number
  • Creating an index
  • Using an index

DATA Step Arrays

  • Introduction to lookup techniques
  • One-dimensional arrays
  • Multidimensional arrays
  • Loading a multidimensional array from a SAS data set

DATA Step Hash and Hiter Objects

  • Hash object methods
  • Loading a hash object from a SAS data set
  • DATA step hiter object

Combining Data Horizontally

  • DATA step merges and SQL procedure joins
  • Using an index to combine data
  • Combining summary and detail data
  • Combining data conditionally

User-Defined Functions and Formats

  • User-defined functions
  • User-defined formats


Sheridan Policies

All Sheridan policies can be viewed on the Sheridan policy website.

Academic Integrity: The principle of academic integrity requires that all work submitted for evaluation and course credit be the original, unassisted work of the student. Cheating or plagiarism including borrowing, copying, purchasing or collaborating on work, except for group projects arranged and approved by the professor, or otherwise submitting work that is not the student's own, violates this principle and will not be tolerated. Students who have any questions regarding whether or not specific circumstances involve a breach of academic integrity are advised to review the Academic Integrity Policy and procedure and/or discuss them with the professor.

Copyright: A majority of the course lectures and materials provided in class and posted in SLATE are protected by copyright. Use of these materials must comply with the Acceptable Use Policy, Use of Copyright Protected Work Policy and Student Code of Conduct. Students may use, copy and share these materials for learning and/or research purposes provided that the use complies with fair dealing or an exception in the Copyright Act. Permission from the rights holder would be necessary otherwise. Please note that it is prohibited to reproduce and/or post a work that is not your own on third-party commercial websites including but not limited to Course Hero or OneNote. It is also prohibited to reproduce and/or post a work that is not your own or your own work with the intent to assist others in cheating on third-party commercial websites including but not limited to Course Hero or OneNote.

Intellectual Property: Sheridan's Intellectual Property Policy generally applies such that students own their own work. Please be advised that students working with external research and/or industry collaborators may be asked to sign agreements that waive or modify their IP rights. Please refer to Sheridan's IP Policy and Procedure.

Respectful Behaviour: Sheridan is committed to provide a learning environment that supports academic achievement by respecting the dignity, self-esteem and fair treatment of every person engaged in the learning process. Behaviour which is inconsistent with this principle will not be tolerated. Details of Sheridan's policy on Harassment and Discrimination, Academic Integrity and other academic policies are available on the Sheridan policy website.

Accessible Learning: Accessible Learning coordinates academic accommodations for students with disabilities. For more information or to register, please see the Accessible Learning website (Statement added September 2016)

Course Outline Changes: The information contained in this Course Outline including but not limited to faculty and program information and course description is subject to change without notice. Any changes to course curriculum and/or assessment shall adhere to approved Sheridan protocol. Nothing in this Course Outline should be viewed as a representation, offer and/or warranty. Students are responsible for reading the Important Notice and Disclaimer which applies to Programs and Courses.


[ Printable Version ]

Copyright © Sheridan College. All rights reserved.