PROG79001
SAS Programming 2: Data Manipulation Techniques
Sheridan
 
  I: Administrative Information   II: Course Details   III: Topical Outline(s)  Printable Version
 

Land Acknowledgement

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
Building on the concepts that are presented in SAS Programming 1: Essentials, this course explores data manipulation techniques using SAS DATA and PROCEDURE steps to access, transform, and summarize SAS data sets.

Program Context

 
SAS Base Programming Program Coordinator(s): N/A
This is the second course that will prepare students for the SAS Certified Base Programmer exam.


Course Critical Performance and Learning Outcomes

  Critical Performance:
Students will have demonstrated the ability to manipulate data using SAS DATA and PROCEDURE.
 
Learning Outcomes:

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

  1. Control SAS data set input and output
  2. Combine SAS data sets
  3. Summarize, read, and write different types of data
  4. Perform DO loop and SAS array processing
  5. Transform character, numeric, and date variables.

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 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): In-Class Assignments/Quizzes
Course Details:

Introduction

  • Course logistics
  • Creating course data files

Controlling Input and Output

  • Writing observations explicitly
  • Writing to multiple SAS data sets
  • Selecting variables and observations

Summarizing Data

  • Creating an accumulating total variable
  • Accumulating totals for a group of data

Reading Raw Data Files

  • Reading raw data files with formatted input
  • Controlling when a record loads

Data Transformations

  • Manipulating character values
  • Manipulating numeric values
  • Converting variable type

Debugging Techniques

  • Using the PUTLOG statement

Processing Data Iteratively

  • DO loop processing
  • Conditional DO loop processing
  • SAS array processing
  • Using SAS arrays

Restructuring a Data Set

  • Rotating with the DATA step

Combining SAS Data Sets

  • Using data manipulation techniques with match-merging

Creating and Maintaining Permanent Formats

  • Creating permanent formats

Other SAS Languages

  • An overview of other languages
  • Using the SQL procedure
  • The SAS macro language


Sheridan Policies

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.

Appropriate use of generative Artificial Intelligence tools: 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.

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. 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.