Section outline

  • Collapse Expand

    General

    Collapse all Expand all


    • Announcements Forum
    • Students must
      Mark as done

      Module Overview

    • Students must
      Mark as done

      Hello everyone, my name is Mr. Dhason Padmakumar (Mr. Dhason for short!) and I am the lecturer responsible for Data Analytical Programming. 
      Please feel free to contact me via MS Teams or email, I am also available for 1-2-1 consultation (Please refer to the iConsult system).  Should you have any queries or questions please reach out, best of luck with the module!

    • Students must
      Mark as done


      Name:

      Mr.DHASON PADMAKUMAR

      Job Title:

      Senior Lecturer & Project Manager (FYP, School of Computing & Technology)

      Email:

      dhason@apu.edu.my

      Contact Number:

      +6 03-8996 1000 (Ext.) or +60 12 27 11 820

      Functional Areas:

      Faculty of Computing, Engineering & Technology

      School of Computing

      Computer Science & Software Engineering

    • Students must
      Mark as done
      Module Synopsis
    • Students must
      Mark as done

      This module will enable students to learn data analytical programming techniques including data acquisition, cleaning, structure, security, and working with customer-centered databases. They will be exposed to practical implementation on analytical techniques using best analytical tools. and deployment of enterprise application in an enterprise-wide context. This module corresponds to CT050-3-M-DAP, therefore please refer to the non-ODL MD if any changes to the module are needed.

    • Students must
      Mark as done
      Course Learning Outcomes
    • Students must
      Mark as done

      CLO1: Assess various forms of data sets by reading, combining and categorizing using data analytical programming techniques. (C5, PLO2)

      CLO2: Produce analytical data models by creating summary reports and enhanced listings. (C6, PLO7)

      CLO3: Formulate visualization and discovery strategies using the datasets given. (A4, PLO5)

  • Collapse Expand

    Module Introduction


    • Students must
      Mark as done

      Overview:

      Welcome to our first class. We will discuss the following matters.

      •Module overview
      •Assessment requirements
      •Teaching strategies

    • Introduction to DAP File
      Students must
      Mark as done
    • Discussion Forum
      Students must
      Mark as done

      Please raise any queries about how the module will be covered as well as the nature of assessments

  • Collapse Expand

    Overview of SAS Foundation


    • Students must
      Mark as done

      Overview

      Learning outcomes:

      This week, you will be learning the following:

      1. Describe the data used in the course
      2. Designate the editors and processing mode available for workshops
      3. Specify the naming convention used for course files
      4. Define the three levels of exercises
      5. Navigate the Help facility

    • Overview of SAS Foundation File
      Students must
      Mark as done
    • Lab Tasks File
      Students must
      Mark as done
    • Discussion Forum
      Students must
      Mark as done

      .

  • Collapse Expand

    Introduction to SAS Programs


    • Students must
      Mark as done

      Overview

      Learning outcomes:

      This week, you will be learning the following:

      1. Use SAS Enterprise Guide to open and submit a SAS program and browse the results.
      2. Use the SAS windowing environment to open and submit a SAS program and browse the results.

    • Introduction to SAS Programs File
      Students must
      Mark as done
    • Lab Tasks File
      Students must
      Mark as done
    • Discussion Forum
      Students must
      Mark as done

      .

  • Collapse Expand

    Accessing Data


    • Students must
      Mark as done

      Overview

      Learning outcomes:

      This week, you will be learning the following:

      1. Define the components of a SAS data set
      2. Browse the descriptor portion of a SAS data set using the CONTENTS procedure
      3. Browse the data portion of a SAS data set using the PRINT procedure
      4. Define a SAS variable
      5. Define a missing value
      6. Define a SAS date value

    • Accessing Data File
      Students must
      Mark as done
    • Lab Tasks File
      Students must
      Mark as done

      .

    • Discussion Forum
      Students must
      Mark as done

      .

  • Collapse Expand

    Producing Detail Reports


    • Students must
      Mark as done

      Overview

      Learning outcomes:

      This week, you will be learning the following:

      1. Create a default PROC PRINT report
      2. Select variables with a VAR statement
      3. Calculate totals with a SUM statement
      4. Select observations with a WHERE statement
      5. Define a date constant
      6. Identify observations with an ID statement

    • Producing Detail Reports File
      Students must
      Mark as done
    • Lab Tasks File
      Students must
      Mark as done

      .

    • Discussion Forum
      Students must
      Mark as done

      .

  • Collapse Expand

    Formatting Data Values & Reading SAS Data Sets


    • Students must
      Mark as done

      Overview

      Learning outcomes:

      This week, you will be learning the following:

      1. Describe SAS formats
      2. Apply SAS formats with the FORMAT statement
      3. Define the business scenario that will be used when reading from a data source to create a SAS data set
      4. Use a DATA step to create a SAS data set from an existing SAS data set
      5. Subset observations with a WHERE statement
      6. Create a new variable with an assignment statement

    • Formatting Data Values & Reading SAS Data Sets File
      Students must
      Mark as done

      ,.

    • Lab Tasks File
      Students must
      Mark as done
    • Discussion Forum
      Students must
      Mark as done

      .

  • Collapse Expand

    Reading Spreadsheet and Database Data & Reading Raw Data Files


    • Students must
      Mark as done

      Overview

      Learning outcomes:

      This week, you will be learning the following:

      1. Assign a libref to a Microsoft Excel workbook using a SAS/ACCESS LIBNAME statement
      2. Access an Excel worksheet using a SAS two-level name
      3. Create a SAS data set using a subset of worksheet data
      4. Identify types of raw data files and input styles
      5. Define the terms standard and nonstandard data

    • Reading Spreadsheet and Database Data & Reading Raw Data Files
      Students must
      Mark as done
    • Lab Tasks File
      Students must
      Mark as done

      .

    • Discussion Forum
      Students must
      Mark as done

      .

  • Collapse Expand

    Manipulating Data & Combining Data Sets


    • Students must
      Mark as done

      Overview

      Learning outcomes:

      This week, you will be learning the following:

      1. Create data values using SAS functions
      2. Concatenate two or more SAS data sets using the SET statement in a DATA step
      3. Change the names of variables using the RENAME= data set option


    • Manipulating Data & Combining Data Sets File
      Students must
      Mark as done

      .

    • Lab Tasks File
      Students must
      Mark as done
    • Discussion Forum
      Students must
      Mark as done

      .

  • Collapse Expand

    Creating Summary Reports


    • Students must
      Mark as done

      Overview

      Learning outcomes:

      This week, you will be learning the following:

      1.Produce one-way and two-way frequency tables with the FREQ procedure.
      2. Enhance frequency tables with options
      3. Use PROC FREQ to validate data in a SAS data set

    • Creating Summary Reports File
      Students must
      Mark as done
    • Lab Tasks File
      Students must
      Mark as done
    • Discussion Forum
      Students must
      Mark as done

      .

  • Collapse Expand

    ASSIGNMENT-QUESTION-AND-MARKING-SCHEME