Postgraduate Course: Working with Data in SAS (CMSE11453)
||College||College of Arts, Humanities and Social Sciences
|Credit level (Normal year taken)||SCQF Level 11 (Postgraduate)
||Availability||Not available to visiting students
|Summary||The aim of the course is to provide the students with the knowledge and skills to work with datasets using SAS programming language. SAS is widely used by in banking for processing and analysing datasets. A brief introduction to Macro Language and basic coding commands is also included in the course.
The course develops computational skills essential to make decisions when working in a bank. The course provides the basic knowledge needed to run programs in a SAS environment, to input and manipulate data, combining and modifying datasets and running statistical procedures using SAS. A basic introduction to coding informatics programs and creating Macro commands will be included.
A selection of topics among:
- Introduction, getting started with SAS
- Sorting, printing and summarising
- Formats and informats
- Manage the variables
- Help and General syntax
- Plotting and graphics
- Macro 1
- Macro 2
- Linear regression
Student Learning Experience
During the course, the students will be experiencing a real contact with the statistic software SAS. The program is introduced using a mixture of demonstration, self-learning and practice. A mixture of on-site, synchronous and asynchronous Q&A sessions will be used for interactions.
Each lecture will consist on a mini-project of increasing difficulty.
Entry Requirements (not applicable to Visiting Students)
||Other requirements|| None
Course Delivery Information
|Academic year 2020/21, Not available to visiting students (SS1)
|Learning and Teaching activities (Further Info)
Lecture Hours 10,
Seminar/Tutorial Hours 10,
Formative Assessment Hours 5,
Programme Level Learning and Teaching Hours 2,
Directed Learning and Independent Learning Hours
|Assessment (Further Info)
|Additional Information (Assessment)
||Case Study Analysis 100% - Assesses LO1, LO2, LO3, LO4.
The case study is composed by the following elements:
- Group 50%
- Peer Assessment 10%
- Individual 40%
The project/assignment will consist of one project consisting of quantitative analysis of business cases in which the students will go through the key steps of the data analysis process. All learning outcomes will be assessed in such assignment. The project will have group work elements (50%) individual work elements (40%) elements and peer assessment elements (10%).
||Feedback on formative assessed work will be provided within 15 working days of submission, or in time to be of use in subsequent assessments within the course, whichever is sooner. Summative marks will be returned on a published timetable, which has been made clear to students at the start of the academic year.
Students will gain feedback on their understanding of the material when they perform computer lab exercises. Students may ask questions in lectures and in forums to assess their knowledge.
|No Exam Information
On completion of this course, the student will be able to:
- Know, understand and critically discuss how SAS programs work.
- Know, understand and critically discuss the main parts of a SAS program.
- Apply the main routines available in SAS for data analysis, to a range of problems.
- Conceptualise and critically evaluate the structure of estimation commands in standard statistical package.
Delwiche, L.D. and Slaughter, S.J (2019) The Little SAS Book: A Primer. 6th edition.
Delwiche, L.D, Ottesen, R.A., and Slaughter, S.J. (2020) Exercises and Projects for The Little SAS Book, Sixth Edition.
McDaniel, S., Hemedinger, C., (2010) Hoboken, N.J. SAS for dummies. Wiley Publishing, Inc.
SAS Institute SAS/STAT User's Guide 9.1.3. http://support.sas.com/onlinedoc/913/docMainpage.jsp
Cody, Ron (2007) Learning SAS by example: a programmer's guide. SAS Institute.
Cody, Ronald P., and Jeffrey K. Smith (1985). Applied statistics and the SAS programming language. North-Holland.
|Graduate Attributes and Skills
On completion of the course a student should be able to:
1. Demonstrate a critical understanding of the role of high-level programming language in analytics.
2. Demonstrate a critical understanding of the potential and limitations of high-level programming language.
3. Demonstrate a critical understanding of the aims and potential of data analytics.
4. Demonstrate a high level understanding of the application of programmes to analyse and manage databases.
5. Conceptualise and critically evaluate the structure of process of analysing datasets, including collection, pre-processing, analysing the data and presenting the results.
6. Demonstrate leadership and/or originality in tackling and resolving problems and issues.
Subject Specific Skills:
After completing this course, students should be able to:
1. Read, run, manipulate and create programs in a SAS environment,
2. Manipulate programs written by others,
3. Input and manipulate data in SAS,
4. Analyse data and estimate regression models using SAS,
5. Develop programs in SAS for repetitive analysis,
6. Use SAS to analyse and manage databases.
|Course organiser||Dr Belén Martín-Barragán
Tel: (0131 6)51 5539
|Course secretary||Ms Rhiannon Pilkington
Tel: (0131 6)50 8072