Summer Fast Track: SAS(R) Base Programming

Kód kurzu: SFTPRB

Tato část není lokalizována

This course is for users who want to learn how to write SAS programs and who need to learn data manipulation techniques using SAS DATA and procedure steps to access, transform, and summarize SAS data sets. It is the entry point to learning SAS programming and is a prerequisite to many other SAS courses. This fast track combines the courses SAS Programming 1: Essentials and SAS Programmierung 2: Datenmanagement

Odborní
certifikovaní lektoři

Mezinárodně
uznávané certifikace

Široká nabídka technických
a soft skills kurzů

Skvělý zákaznický
servis

Přizpůsobení kurzů
přesně na míru

Termíny kurzu

Počáteční datum: Na vyžádání

Forma: Na vyžádání

Délka kurzu: 35 hodin

Jazyk: en

Cena bez DPH: 75 000 Kč

Registrovat

Počáteční
datum
Místo
konání
Forma Délka
kurzu
Jazyk Cena bez DPH
Na vyžádání Na vyžádání 35 hodin en 75 000 Kč Registrovat
G Garantovaný kurz

Nenašli jste vhodný termín?

Napište nám o vypsání alternativního termínu na míru.

Kontakt

Cílová skupina

Tato část není lokalizována

Programmers, business analysts, and anyone getting started writing SAS programs

Struktura kurzu

Tato část není lokalizována

Introduction

  • Course logistics.
  • Overview of Foundation SAS.

Getting Started with SAS

  • Introduction to SAS programs.
  • Submitting a SAS program.

Working with SAS Syntax

  • Mastering fundamental concepts.
  • Diagnosing and correcting syntax errors.

Getting Familiar with SAS Data Sets

  • Examining descriptor and data portions.
  • Accessing SAS data libraries.
  • Accessing relational databases (self-study).

Reading SAS Data Sets

  • Introduction to reading data.
  • Using SAS data as input.
  • Subsetting observations and variables.
  • Adding permanent attributes.

Reading Microsoft Excel Worksheets

  • Using Excel data as input.
  • Doing more with Excel worksheets (self-study).

Reading Delimited Raw Data Files

  • Using standard delimited data as input.
  • Using nonstandard delimited data as input.

Validating and Cleaning Data

  • Introduction to validating and cleaning data.
  • Examining data errors when reading raw data files.
  • Validating data with the PRINT and FREQ procedures.
  • Validating data with the MEANS and UNIVARIATE procedures.
  • Cleaning invalid data.

Manipulating Data

  • Creating variables.
  • Creating variables conditionally.
  • Subsetting observations.

Combining SAS Data Sets

  • Introduction to combining data sets.
  • Appending a data set (self-study).
  • Concatenating data sets.
  • Merging data sets one to one.
  • Merging data sets one to many.
  • Merging data sets with nonmatches.

Enhancing Reports

  • Using global statements.
  • Adding labels and formats.
  • Creating user-defined formats.
  • Subsetting and grouping observations.
  • Directing output to external files.

Producing Summary Reports

  • Using the FREQ procedure.
  • Using the MEANS procedure.
  • Using the TABULATE procedure (self-study).

Introduction to Graphics Using SAS/GRAPH (Self-Study)

  • Creating bar and pie charts.
  • Creating plots.
  • Enhancing output.

Controlling Input and Output

  • Writing observations explicitly.
  • Writing to multiple SAS data sets.
  • Selecting variables and observations.

Summarizing Data

  • Creating an accumulating total variable.
  • Accumulating totals for a group of data.

Reading Raw Data Files

  • Reading raw data files with formatted input.
  • Controlling when a record loads.

Data Transformations

  • Manipulating character values.
  • Manipulating numeric values.
  • Converting variable type.

Debugging Techniques

  • Using the PUTLOG statement.

Processing Data Iteratively

  • DO-loop processing.
  • Conditional DO-loop processing.
  • SAS array processing.
  • Using SAS arrays.

Restructuring a Data Set

  • Rotating with the DATA step.

Combining SAS Data Sets

  • Using data manipulation techniques with match-merging.

Creating and Maintaining Permanent Formats

  • Creating permanent formats.

Other SAS Languages

  • Overview of other languages.
  • Using the SQL procedure.
  • Using SAS macro language.

Learning More

  • SAS resources.
  • Next steps.

Předpokládané znalosti

Tato část není lokalizována

Before attending this course, you should have experience using computer software.

Potřebujete poradit nebo upravit kurz na míru?

onas

produktová podpora

Platební brána ComGate Logo MasterCard Logo Visa