search

I WOULD LIKE TO

QR
Querying and Reporting by SAS Enterprise Guide
SHARE
Querying and Reporting by SAS Enterprise Guide
  • Overview
  • Objectives & Outline
  • Methodology
  • Participant Profile
  • Trainer
  • Overview
    PROGRAMME DETAILS

    DATE

    27 – 28 August 2018

    TIME

    9:00 AM – 5:00 PM

    VENUE

    SAS Institute, Menara CIMB, KL Sentral
    14
    AICB
    CPD HOURS
    This programme is for users who do not have SAS programming experience but need to access, manage, and summarize data from different sources, and present results in reports and graphs. It focuses on using the menu-driven tasks in the SAS Enterprise Guide; the point-and-click interface to SAS to create queries and reports. It does not address writing SAS code or statistical concepts.
    Learning Level
    Intermediate
    Programme Fee*

    AICB MEMBER

    MYR

    4,200

    / PAX

    NON-MEMBER

    MYR

    4,700

    / PAX

    *inclusive of GST 
  • Objectives & Outline
    LEARNING OBJECTIVES
    By the end of the programme, participants will be able to:
    • Access and manipulate local and remote data of various types
    • Create queries that filter and summarize data, compute new columns and join multiple tables
    • Create frequency and tabular reports
    • Create interactive graphs
    • Automate output results
    PROGRAMME OUTLINE
    Getting Started
    • Introducing SAS Enterprise Guide
    • Course scenarios

    Working with Data in a Project
    • Understanding the SAS data structure
    • Accessing SAS and DBMS data
    • Importing data files

    Getting Started with Tasks
    • Introduction to tasks and wizards
    • Creating a frequency report
    • Generating HTML, PDF, and RTF output
    • Creating a listing report
    • Filtering data in a task
    • Creating a graph

    Creating Simple Queries
    • Filtering and sorting data
    • Creating new columns with an expression
    • Grouping and summarizing data in a query
    • Joining tables

    Creating Summarized Output
    • Generating summary statistics
    • Creating a summary report with the Summary Tables task

    Using Prompts in Tasks and Queries
    • Prompting in projects
    • Creating and using prompts in tasks
    • Creating and using prompts in queries

    Customising and Organising Project Results
    • Combining results
    • Updating and organising projects

    Learning More
    • SAS resources
    • Beyond this programme

    Writing and Submitting SAS Programmes
    • Writing and submitting SAS programmes
  • Methodology
    Interactive lectures with a classroom style
  • Participant Profile
    Data, business, and statistical analysts who are licensed or are considering SAS Enterprise Guide or SAS Analytics Pro licensing, and would like to get started with data access, management, and analysis. Participants attending should already be familiar with Windows and software like Microsoft Office or spreadsheet programmes. Suitable for users with no programming experience or SAS knowledge.
  • Trainer

    Fui Choon Chu

    Fui Choon Chu has 20 years’ experience in Data Mining across Banking, Insurance, Casino and Manufacturing industries. Prior to becoming an independent consultant, she worked in Database Marketing, Marketing Analytics, Decision Management, Customer Intelligence, Risk Scoring and Analytics for multinational companies such as Western Digital, AIG, Citibank (AVP – Decision Management), Genting Resorts (Head – Customer Intelligence Unit), Hong Leong Bank (Head – Scoring & Analytics) and Standard Chartered Bank (Senior Manager – Credit & Collections) in Malaysia and in America when selected as the Citigroup Global Talent Associate in 2005. She has conducted and trained professionals, especially in the financial sector, in data mining with SAS tools.

REGISTER NOW
Please complete the following form to register with us. Alternatively, you can email us here or call us at +603 2742 7822 if you have any questions.
PAYMENT PROCESS

1

Please download the Payment Form for our Banking details and if making company sponsored payments

2

Upload your Payment Form/Receipt and submit with your online registration

3

You will receive a confirmation email upon successful registration
I'm Applying For
Programme Details
Select Programme
Please select a time slot.
FULL NAME
(as per NRIC/Passport) *
New NRIC No/Passport No*
Nationality*
Email*
Contact No*
Job Title/ Designation*
Department*
Company Name*
Mailing Address*
City*
Postcode*
Country*
AICB Membership No
(If Applicable)
Special Remarks
(IF APPLICABLE, PLEASE FILL IN YOUR FMAM (PPKM) MEMBERSHIP NUMBER HERE)
Upload Payment Receipt or Form*
*Required fields
Captcha validation failed.
Thank you for your submission. You should receive an automated email shortly at the email address you provided if the submission had gone through successfully. If you do not receive the email, please contact us at +603-2742 7822 or email training@asianbankingschool.com
There are currently no upcoming Programme slots.
Please email us here or call us at +603 2742 7822 if you want to check on future slots.

Copyright © Asian Banking School (ABS). All rights reserved.

 CONNECT WITH US

Ooops!
Generic Popup