Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due

MANG1041 Business Analytics Programming I: SAS Base Language

Module overview

This course provides part of the essential knowledge and skills required for conducting the Final Project module in the final year.

SAS (Statistical Analysis System) is the leading data analytics software package. This module will cover the fundamentals of SAS base programming. On successful completion of this module, you will be able to use SAS software to read data, access, manage and manipulate ‘big’ data, solve problems, save programs and datasets, use conditional logic, combine files, produce tables and listings of data, and use data analysis techniques. The module will also help prepare you for the SAS Base programming certification.

Linked modules

Pre-Requisites: MANG1019 or MANG1007 or MANG1047

Aims and Objectives

Learning Outcomes

Knowledge and Understanding

Having successfully completed this module, you will be able to demonstrate knowledge and understanding of:

• manipulate, analyse, visualize and report data using SAS.
• the SAS Base language and how it is used to manage, analyse and report data;
• key computer programming concepts for managing and analysing ‘big data';

Subject Specific Intellectual and Research Skills

Having successfully completed this module you will be able to:

• read structured and unstructured data stored in popular formats such as excel worksheets, text tables into SAS;
• store data in SAS libraries.

Transferable and Generic Skills

Having successfully completed this module you will be able to:

• use your analytic skills in problem solving;
• communicate technical ideas to non-specialist managers.

Syllabus

The topics covered in this module will include:

• Overview of SAS: Submitting SAS programs, Working with SAS syntax and SAS libraries
• Introduction to reading data and adding attributes: Reading Excel worksheets, Reading delimited raw data files
• Manipulating data in SAS: Combining SAS Datasets, Producing Summary Reports, Enhancing Reports using Global statements and using ODS, Outputting to multiple datasets or observations
• Reading Raw Data Files with input controls: Data Transformations-manipulating character and numeric values, Debugging Techniques- putlog and debug
• Processing Data Iteratively- Do loops and Arrays, Restructuring a Data Set with rotate and transpose, Analysing relationships among variables: proc corr, regression and logistic

Learning and Teaching

Teaching and learning methods

Teaching methods include:

• Lectures
• Interactive case studies
• Computer labs
• Directed reading
• Private/guided study

Learning activities include:

• Introductory lectures
• 2 assignments (individual written coursework)
• Case study
• In class debate and discussion
• Private study
• Use of video and online materials

Resources & Reading list

Textbooks

Peng, J.C.Y (2009). Data Analysis Using SAS. Sage.

Sas Institute (2011). SAS Certification Prep Guide: Base Programming for SAS 9. SAS Institute.

Assessment

Formative

This is how we’ll give you feedback as you are learning. It is not a formal test or exam.

Class participation

• Assessment Type: Formative
• Feedback:
• Final Assessment: No
• Group Work: No

Summative

This is how we’ll formally assess what you have learned in this module.

Referral

This is how we’ll assess you if you don’t meet the criteria to pass this module.

Repeat

An internal repeat is where you take all of your modules again, including any you passed. An external repeat is where you only re-take the modules you failed.

Repeat Information

Repeat type: Internal & External