Detail kurzu

Summer Fast Track: SAS(R) Advanced Programming

EDU Trainings s.r.o.

Popis kurzu

This course is for users who want to learn more advanced functionality for writing SAS programs, with a focus on applying efficiency techniques, using SAS macro code, and processing SAS data using Structured Query Language (SQL). The "fast track" format for this offering combines the SAS Programming 3: Advanced Techniques, SAS Macro Language 1: Essentials, and SAS SQL 1: Essentials courses. The course provides an introduction to SQL processing, and access to the e-learning version of the Essentials course is provided so that students can study the subject matter independently.

Obsah kurzu

Introduction to SAS Programming 3Overview of SAS Foundation.Course logistics.Creating the course data.Efficient SAS ProgrammingIdentifying computer resources related to efficiency.Controlling I/O Processing and MemorySAS DATA step processing.Controlling I/O.Reducing the length of numeric variables.Compressing SAS data sets.Using SAS views.Accessing ObservationsAccess methods.Accessing observations by number.Creating an index.Using an index.DATA Step ArraysIntroduction to lookup techniques.One-dimensional arrays.Multidimensional arrays.Loading a multidimensional array from a SAS data set.DATA Step Hash and Hiter ObjectsIntroduction.Hash object methods.Loading a hash object from a SAS data set.DATA step hiter object.Combining Data HorizontallyDATA step merges and SQL procedure joins.Using an index to combine data.Combining summary and detail data.Combining data conditionally.User-Defined Functions and FormatsCombining Raw Data Files VerticallyIntroduction to SAS MacroOverview of SAS Foundation.Course logistics.Purpose of the macro facility.Program flow.Macro VariablesIntroduction to macro variables.Automatic macro variables.Macro variable references.User-defined macro variables.Delimiting macro variable references.Macro functions.Macro DefinitionsDefining and calling a macro.Macro parameters.DATA Step and SQL InterfacesCreating macro variables in the DATA step.Indirect references to macro variables.Creating macro variables in SQL.Macro ProgramsConditional processing.Parameter validation.Iterative processing.Global and local symbol tables.Supplemental Materials: Program FlowIntroduction to SAS SQL Procedures

Cílová skupina

Experienced SAS programmers
Certifikát Na dotaz.
Hodnocení




Organizátor