Cuenca, Ecuador

Data Analytics and BI

SAS Advanced Programming Training Programin Cuenca

Advance your analytics capabilities with SAS Advanced Programming Training in Cuenca, Ecuador . Master macro programming, advanced DATA step techniques, PROC SQL, arrays, hash objects, data optimisation, automation, and reporting. Build…

40–50 Hours/5-6 daysLive virtual trainingIntermediate

Training is delivered live online for learners in Cuenca, Ecuador. Corporate programs are available for teams; request a quotation to confirm the schedule.

Plan your attendance

Training information for Cuenca

Selected country and city time: Europe/London. Times follow the selected country and city. Choose another time zone below if needed.

Training information for Cuenca
DeliveryLive online · Classroom when confirmed
Price$799 USD

Bookings and payments are in USD only.

ScheduleCourse-page batches starting in the next 7 days; subject to availability
Exam voucherCheck with StepMerit
Classroom venueClient premises or a StepMerit-arranged conference hall in Cuenca, subject to venue and batch confirmation.
Weekend · 5 training days

Starts Nov 21, 2026, 9:00 AM

First session ends Nov 21, 2026, 3:00 PM

Europe/London · Weekend hours are flexible. Schedule and delivery subject to confirmation.

Enquire about this batch
Weekday · 5 training days

Starts Nov 23, 2026, 9:00 AM

First session ends Nov 23, 2026, 5:00 PM

Europe/London · Schedule and delivery subject to confirmation.

Enquire about this batch
Corporate batches

Chat with us on WhatsApp to arrange training for your team.

What you will learnExpand syllabus +

Module 1: Advanced SAS Programming Concepts

  • Review of SAS Base programming fundamentals
  • Advanced SAS program structure and execution
  • Understanding SAS processing and execution flow
  • Advanced DATA step programming techniques
  • Working with complex datasets and variables

Module 2: Advanced DATA Step Processing

  • Advanced DATA and SET statement applications
  • Conditional processing using IF-THEN-ELSE
  • DO loops and iterative DATA step processing
  • Multiple DATA step operations
  • Retaining values using RETAIN statements

Module 3: Advanced SAS Functions

  • Advanced character and numeric functions
  • Date and time manipulation functions
  • Conversion functions and data type handling
  • Conditional and comparison functions
  • Creating calculated variables using SAS functions

Module 4: Arrays and Iterative Programming

  • Introduction to SAS arrays
  • Defining and referencing array elements
  • Processing multiple variables using arrays
  • Using DO loops with arrays
  • Array-based data transformation techniques

Module 5: Advanced Dataset Management

  • Advanced dataset merging and combining
  • One-to-one and one-to-many dataset matching
  • BY-group processing and data consolidation
  • Advanced sorting and subsetting techniques
  • Dataset restructuring and transformation

Module 6: Advanced PROC SQL Programming

  • Advanced SELECT statement applications
  • Inner, left, right, and full joins
  • Subqueries and nested SQL operations
  • GROUP BY, HAVING, and aggregate functions
  • Creating and modifying tables using PROC SQL

Module 7: SAS Macro Programming Fundamentals

  • Introduction to SAS macro language
  • Creating and using macro variables
  • Defining and executing macro programs
  • Understanding macro statements and functions
  • Passing parameters to SAS macros

Module 8: Advanced Macro Programming

  • Conditional macro processing
  • Iterative macro programming
  • Macro variable scope and resolution
  • Dynamic code generation using macros
  • Developing reusable programming components

Module 9: Hash Objects and Advanced Lookup Techniques

  • Introduction to SAS hash objects
  • Creating and defining hash objects
  • Adding, retrieving, and searching hash entries
  • Using hash objects for dataset lookups
  • Applying hash techniques to complex data operations

Module 10: Advanced Data Transformation and Restructuring

  • Advanced data transformation methods
  • Transposing datasets using PROC TRANSPOSE
  • Restructuring wide and long datasets
  • Managing multiple observations and variables
  • Preparing analytical datasets for reporting

Module 11: Advanced Reporting and Output Management

  • Advanced PROC REPORT techniques
  • Customising report structures and layouts
  • Generating grouped and summarised reports
  • Managing SAS output and log information
  • Preparing structured reports for business users

Module 12: SAS Performance Optimisation

  • Understanding SAS program execution efficiency
  • Optimising DATA step processing
  • Efficient dataset sorting and merging
  • Reducing unnecessary data operations
  • Improving performance when working with large datasets

Module 13: Advanced Data Validation and Quality Management

  • Advanced missing-value management
  • Identifying duplicate and inconsistent records
  • Applying data validation rules
  • Implementing data quality checks
  • Preparing reliable datasets for analytical applications

Module 14: Practical SAS Advanced Programming Project

  • Importing and processing complex industry datasets
  • Applying advanced DATA step and array techniques
  • Developing reusable SAS macros
  • Using PROC SQL for advanced data retrieval
  • Generating structured analytical reports and project documentation

Module 15: Final Assessment and Practical Evaluation

  • Advanced SAS programming knowledge assessment
  • Macro programming and DATA step exercises
  • Advanced SQL and dataset manipulation tasks
  • Performance and data quality evaluation
  • Final practical project presentation and review

StepMerit will make the necessary arrangements to provide the required lab environment. Lab costs, where applicable, will be charged separately.

Exam details

  • Exam Level: Intermediate to Advanced SAS Programming.
  • Exam Type: Suggested internal assessment combining multiple-choice questions, programming exercises, and scenario-based problems.
  • Number of Questions: Approximately 40 questions.
  • Exam Duration: 90 minutes.
  • Suggested Passing Score: 70% (28 out of 40 questions).
  • Programming Assessment: Advanced DATA step processing, arrays, hash objects, conditional logic, and iterative programming.
  • Macro Programming: Assessment of macro variables, macro statements, reusable code, and automated program generation.
  • Advanced PROC SQL: Evaluation of complex queries, joins, subqueries, grouping, and data retrieval techniques.
  • Dataset Management: Practical questions covering advanced merging, sorting, restructuring, transformation, and data validation.
  • Performance Optimisation: Understanding efficient SAS coding practices and techniques for processing large datasets.
  • Practical Project: Complete an industry-oriented programming assignment involving complex data processing, automation, and analytical reporting.
  • Certification: Eligible learners may receive a StepMerit Learning Certificate of Completion, subject to programme requirements.

Plan your learning

Who this course is for

- Experienced SAS Base Programmers: Professionals familiar with SAS fundamentals who want to advance their skills in DATA step programming, arrays, hash objects, and complex dataset transformations. - Senior Data Analysts: Data professionals seeking advanced SAS capabilities to process large datasets, automate analytical tasks, perform complex queries, and generate business intelligence reports. - Healthcare Data Analysts and Administrators: Healthcare professionals interested in managing patient-related datasets, analysing hospital service information, preparing claims reports, and supporting healthcare analytics using synthetic or appropriately protected data. - Statistical Programmers…

Before you begin

SAS Base Programming Knowledge: Familiarity with SAS programming syntax, DATA step processing, SAS libraries, datasets, and essential PROC procedures is recommended. DATA Step Experience: Understanding of DATA and SET statements, variables, formats, informats, conditional processing, and dataset manipulation will help learners progress through advanced programming concepts. Data Management Fundamentals: Basic experience with importing, cleaning, sorting, filtering, merging, and validating structured datasets is beneficial. PROC SQL Familiarity: Working knowledge of SELECT, WHERE, GROUP BY, sorting, and basic joins is useful for advanced SQL operations in SAS. Programming and Logical…

Learning outcomes

Problem Statement – A healthcare organisation manages large volumes of patient records, hospital admission details, treatment information, laboratory results, insurance claims, and operational data. Information stored across different departments can contain duplicate entries, inconsistent formats, missing values, and disconnected records. These challenges affect data quality, reporting accuracy, and the timely preparation of healthcare analytics. The goal is to demonstrate how advanced SAS programming can support efficient data processing, structured reporting, and reliable healthcare data management. How We Overcame the Problem – Learners applied advanced SAS programming techniques, DATA…

Related reading

Course blogs for learners in Cuenca

Explore this course locally

Know the location

Local information: Cuenca

Cuenca, Ecuador. View city location ↗

City overview

Cuenca, Ecuador.

Geography & administration

Time zone: Europe/London.

Education & learning

Course learning optionsExplore SAS Advanced Programming Training Program through live online instructor-led training. Cuenca learners can request a corporate program for their teams. Course duration: 40–50 Hours/5-6 days. Check the upcoming online batches and contact StepMerit to confirm the schedule and exam arrangements.