+44 7459 302492
info@uplatz.com
Job Meter = High
SAS Certified Professional: Advanced Programming Using SAS 9.4
30 Hours
Online Instructor-led Training
USD 1399 (
About this Course
SAS SQL 1: Essentials
This course teaches you how to process SAS data using Structured Query Language (SQL).
Learn how to- Query and subset data.
- Summarize and present data.
- Combine tables using joins and set operators.
- Create and modify tables and views.
- Create data-driven macro variables using a query.
- Access DBMS data with SAS/ACCESS technology.
SAS Macro Language 1: Essentials
This course focuses on using the SAS macro facility to design, write, and debug macro programs, with an emphasis on understanding how programs that contain macro code are processed.
- Perform text substitution in SAS code.
- Use macro variables and macro functions.
- Automate and customize the production of SAS code.
- Conditionally or iteratively construct SAS code.
- Write self-modifying, data-driven programs.
SAS Programming 3: Advanced Techniques
This course is for SAS programmers who want to learn advanced techniques within the DATA step and procedures.
Learn how to- Use additional functions (LAG, FINDC/FINDW, and COUNT/COUNTC/COUNTW).
- Perform pattern matching using PRX functions.
- Process repetitive code, rotate data, and perform table lookups using arrays.
- Perform table lookups and sort data using hash and hash iterator objects.
- Create numeric templates using the FORMAT procedure.
- Create custom functions using the FCMP procedure.
Target Audience
SAS programmers and business analysts
Experienced SAS programmers who are familiar with simple SQL queries and well-versed in DATA step processing and who want to write reusable, dynamic programs and automate repetitive processing in SAS
Experienced SAS programmers
-----------------------------------------------------------------------
SAS Certified Professional: Advanced Programming Using SAS 9.4
Course Details & Curriculum
SAS SQL 1: Essentials
Essentials- Setting up for this course.
- Overview of SAS Foundation.
- Course logistics.
- Course data files.
- Introducing the Structured Query Language.
- Overview of the SQL procedure.
- Exploring tables.
- Specifying columns.
- Subsetting data.
- Presenting data.
- Summarizing data.
- Creating and managing tables.
- Using DICTIONARY tables.
- Introduction to SQL joins.
- Inner joins.
- Outer joins.
- Complex SQL joins.
- Noncorrelated subqueries.
- Correlated subqueries.
- In-line views.
- Creating views with the SQL procedure.
- Subqueries in the SELECT clause.
- Remerging summary statistics.
- Introduction to set operators.
- The INTERSECT operator.
- The EXCEPT operator.
- The UNION operator.
- The OUTER UNION operator.
- Interfacing PROC SQL with the macro language.
- Creating data-driven macro variables with a query.
- Using macro variables in SQL.
- Overview of SAS/ACCESS technology.
- SQL pass-through facility.
- SAS/ACCESS LIBNAME statement.
- PROC FedSQL.
SAS Macro Language 1: Essentials
Introduction
- Why SAS macro?
- Setting up for this course.
- Program flow.
- Creating and using macro variables.
- Macro functions.
- Using SQL to create macro variables.
- Using the DATA step to create macro variables.
- Indirect references to macro variables.
- Defining and calling a macro.
- Macro variable scope.
- Conditional processing.
- Iterative processing.
- Storing macros.
- Generating data-dependent code.
- Validating parameters and documenting macros.
SAS Programming 3: Advanced Techniques
Getting Started- Setting up for this course.
- DATA step review.
- Using a variety of advanced functions.
- Performing pattern matching with Perl regular expressions.
- Defining and referencing one-dimensional arrays.
- Doing more with one-dimensional arrays.
- Defining and referencing two-dimensional arrays.
- Declaring hash objects.
- Defining hash objects.
- Finding key values in a hash object.
- Writing a hash object to a table.
- Using hash iterator objects.
- Creating picture formats with the FORMAT procedure.
- Creating functions with the FCMP procedure.
