PROG79000
SAS Programming 1: Essentials |
|
|
|
|
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:
N/A
|
|
|
Section II: Course Details
|
Detailed Description
This course is the entry-point to learning SAS programming. Navigate SAS Studio, Enterprise Guide and Windowing environments. Working with different datasets, students will learn how to combine datasets, create SAS variables and data subsets.
Program Context
|
SAS Base Programming |
Program Coordinator(s):
N/A |
This is the first course of the program. It will introduce students to Base SAS and its different environments.
|
|
Course Critical Performance and Learning Outcomes
|
Critical Performance: |
| Students will have demonstrated the ability to create SAS programs using basic concepts.
|
|
Learning Outcomes:
To achieve the critical performance, students will have demonstrated the ability to:
|
|
- Navigate the SAS Studio programming environment
- Navigate the SAS Enterprise Guide programming environment
- Navigate the SAS windowing environment
- Read various types of data into SAS data sets
- Create SAS variables and subset data
- Combine SAS data sets
- Create and enhance listing and summary reports.
|
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: N/A
Resource(s): N/A
Applicable student group(s): Continuing and Professional Studies students.
Course Details: Introduction - overview of SAS Foundation
- course logistics
- course data files
SAS Programs
- introduction to SAS programs
- submitting a SAS program
- SAS program syntax
Accessing Data
- examining SAS data sets
- accessing SAS libraries
Producing Detail Reports
- subsetting report data
- sorting and grouping report data
- enhancing reports
Formatting Data Values
- using SAS formats
- creating user-defined formats
Reading SAS Data Sets
- reading a SAS data set
- customizing a SAS data set
Reading Spreadsheet and Database Data
- reading spreadsheet data
- reading database data
Reading Raw Data Files
- introduction to reading raw data files
- reading standard delimited data
- reading nonstandard delimited data
- handling missing data
Manipulating Data
- using SAS functions
- conditional processing
Combining Data Sets
- concatenating data sets
- merging data sets one-to-one
- merging data sets one-to-many
- merging data sets with nonmatches
Creating Summary Reports
- using the FREQ procedure
- using the MEANS and UNIVARIATE procedures
- using the Output Delivery System
|
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. |