PROG79002
SAS Programming 3: Advanced Techniques and Efficiencies |
|
|
|
|
Sheridan College resides on land that has been, and still is, the traditional territory of several Indigenous nations, including the Anishinaabe, the Haudenosaunee Confederacy, the Wendat, and the Mississaugas of the Credit First Nation. We recognize this territory is covered by the Dish with One Spoon treaty and the Two Row Wampum treaty, which emphasize the importance of joint stewardship, peace, and respectful relationships.
As an institution of higher learning Sheridan embraces the critical role that education must play in facilitating real transformational change. We continue our collective efforts to recognize Canada's colonial history and to take steps to meaningful Truth and Reconciliation.
|
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:
|
|
- Benchmark computer resource usage
- Control memory, I/O, and CPU resources
- Create and use indexes
- Combine data horizontally
- Use hash and hiter DATA step component objects and arrays as lookup tables
- Compress SAS data sets
- Sample your SAS data sets
- Create and use SAS data views
- Safely reduce the length of numeric variables
- Create user-defined functions and informats.
|
Evaluation Plan
Students demonstrate their learning in the following ways:
| Evaluation Plan: IN-CLASS
| In-Class Assignments/Quizzes | 100.0% | | Total | 100.0% |
|
Provincial Context
The course meets the following Ministry of Colleges and Universities requirements:
|
Prior Learning Assessment and Recognition
PLAR Contact (if course is PLAR-eligible) - Office of the Registrar
|
|
|
|
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
|
It is recommended that students read the following policies in relation to course outlines:
- Academic Integrity
- Copyright
- Intellectual Property
- Respectful Behaviour
- Accessible Learning
All Sheridan policies can be viewed on the Sheridan policy website.
In alignment with Sheridan's Academic Integrity Policy, students should consult with their professors and/or refer to evaluation instructions regarding the appropriate use, or prohibition, of generative Artificial Intelligence (AI) tools for coursework. Turnitin AI detection software may be used by faculty members to screen assignment submissions or exams for unauthorized use of artificial intelligence.
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. 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. |