WSQ - SAS Programming 1: Essentials
TGS-2023039894
Course Overview
This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It lays a foundation for data science, machine learning, and artificial intelligence practitioners and a pre-requisite for subsequent SAS data science courses.
Training Type
Full Time
Mode of Assessment
Written & Practical Assessment
Who Should Attend
Anyone starting to write SAS programs
Course Duration
3 Days
Total Training Duration (Hour)
22.5 Hours
Course Outline
Module 1: Essentials
Module 2: Accessing Data
Module 3: Exploring and Validating Data
Module 4: Preparing Data
Module 5: Analyzing and Reporting on Data
Module 6: Exporting Results
Module 7: Using SQL in SAS
Certification Obtained and Conferred by
- Avantus Certificate of Attendance (upon achieving minimum 75% class attendance)
- WSQ Statement of Attainment (upon passing the relevant assessment)
- To download WSQ e-Certs, Learners can log in to MySkillsFuture portal via SingPass > go to Skills Passport > Certificates
Course Learning Outcome
Upon completion of course, learners will be able to:
- Use SAS Studio and SAS Enterprise Guide to write and submit SAS programs.
- Access SAS, Microsoft Excel, and text data
- Explore and validate data
- Prepare data by subsetting rows and computing new columns
- Analyze and report on data
- Export data and results to Excel, PDF, and other formats
- Use SQL in SAS to query and join tables
Pre-requisites
- Be able to listen and speak English at a proficiency level equivalent to the Employability Skills Workforce Skills Qualifications (ES WSQ) Workplace Literacy (WPL) level 6; and
- Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 6; and
- Be able to manipulate numbers at a proficiency level equivalent to ES WSQ WPN level 6
- The minimum age of course participants should be 21 years
- Experience using computers hardware, operating systems like Microsoft Windows and file management
- Have basic familiarity using software applications and able to navigate general software interfaces
Medium of Instruction & Trainer
English
Funding Information
SSG WSQ Certifiable Funding
Criteria(s):
- Applicant must either be a Singapore Citizen or Permanent Resident of Singapore and;
- Applicant must be at least 21 years old and;
- Applicant must achieve at least 75% attendance, and pass all examinations/assessments and;
- Applicant is taking the course for the first time
Avantus reserves the right to charge the full course fee (without subsidy) if any of the conditions above are not met.
SSG Funding Validity Period
14 Nov 2023 - 13 Nov 2025
Additional Notes
Assessment Retake fee at $200 (before GST)
Course Pre-Requisites
Documents
Price
| Course Fee Payable | ||
|---|---|---|
| Original Fee | Before GST | With GST (9%) |
| Course Fee | $2,160.00 | $2,354.40 |
| Individual Pricing (Fee payable to Training Provider) | Before GST | With GST (9%) |
| SkillsFuture >=40 years old, Singapore Citizens | $648.00 | $842.40 |
| SkillsFuture >=21 years old | $1,080.00 | $1,274.40 |
| Corporate Pricing (Fee payable to Training Provider) | ||
| Non-SME | Before GST | With GST (9%) |
| SkillsFuture >=21 years old | $1,080.00 | $1,274.40 |
| SkillsFuture >= 40 years old | $648.00 | $842.40 |
| SME | Before GST | With GST (9%) |
| SkillsFuture | $648.00 | $842.40 |
Please note that prices are subjected to change.
