Summer Fast Track: SAS(R) Advanced Programming

Kód kurzu: SFTPRA

Táto časť nie je lokalizovaná

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.

Odborní
certifikovaní lektori

Mezinárodne
uznávané certifikácie

Široká ponuka technických
a soft skills kurzov

Skvelý zákaznicky
servis

Prispôsobenie kurzov
presne na mieru

Termíny kurzov

Počiatočný dátum: Na vyžiadanie

Forma: Na vyžiadanie

Dĺžka kurzu: 52h 30min

Jazyk: en

Cena bez DPH: 4 800 EUR

Registrovať

Počiatočný
dátum
Miesto
konania
Forma Dĺžka
kurzu
Jazyk Cena bez DPH
Na vyžiadanie Na vyžiadanie 52h 30min en 4 800 EUR Registrovať
G Garantovaný kurz

Nenašli ste vhodný termín?

Napíšte nám o vypísanoe alternatívneho termínu na mieru.

Kontakt

Cieľová skupina

Táto časť nie je lokalizovaná

Experienced SAS programmers

Štruktúra kurzu

Táto časť nie je lokalizovaná

Introduction to SAS Programming 3

  • Overview of SAS Foundation.
  • Course logistics.
  • Creating the course data.

Efficient SAS Programming

  • Identifying computer resources related to efficiency.

Controlling I/O Processing and Memory

  • SAS DATA step processing.
  • Controlling I/O.
  • Reducing the length of numeric variables.
  • Compressing SAS data sets.
  • Using SAS views.

Accessing Observations

  • Access methods.
  • Accessing observations by number.
  • Creating an index.
  • Using an index.

DATA Step Arrays

  • Introduction to lookup techniques.
  • One-dimensional arrays.
  • Multidimensional arrays.
  • Loading a multidimensional array from a SAS data set.

DATA Step Hash and Hiter Objects

  • Introduction.
  • Hash object methods.
  • Loading a hash object from a SAS data set.
  • DATA step hiter object.

Combining Data Horizontally

  • DATA step merges and SQL procedure joins.
  • Using an index to combine data.
  • Combining summary and detail data.
  • Combining data conditionally.

User-Defined Functions and Formats

Combining Raw Data Files Vertically

Introduction to SAS Macro

  • Overview of SAS Foundation.
  • Course logistics.
  • Purpose of the macro facility.
  • Program flow.

Macro Variables

  • Introduction to macro variables.
  • Automatic macro variables.
  • Macro variable references.
  • User-defined macro variables.
  • Delimiting macro variable references.
  • Macro functions.

Macro Definitions

  • Defining and calling a macro.
  • Macro parameters.

DATA Step and SQL Interfaces

  • Creating macro variables in the DATA step.
  • Indirect references to macro variables.
  • Creating macro variables in SQL.

Macro Programs

  • Conditional processing.
  • Parameter validation.
  • Iterative processing.
  • Global and local symbol tables.

Supplemental Materials: Program Flow

Introduction to SAS SQL Procedures

Predpokladané znalosti

Táto časť nie je lokalizovaná

This course is not appropriate for beginning SAS software users. Before attending this course, you should have at least several months of SAS programming experience, or you should have completed the SAS Programmierung 2: Datenmanagement course and master the topics introduced during that course.

Potrebujete poradiť alebo upraviť kurz na mieru?

pruduktová podpora