SAS(R) Programming Fast Track

Kód kurzu: PRGFST

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: 35 hodín

Jazyk: en

Cena bez DPH: 3 000 EUR

Registrovať

Počiatočný
dátum
Miesto
konania
Forma Dĺžka
kurzu
Jazyk Cena bez DPH
Na vyžiadanie Na vyžiadanie 35 hodín en 3 000 EUR Registrovať
G Garantovaný kurz

Nenašli ste vhodný termín?

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

Kontakt

Štruktúra kurzu

Táto časť nie je lokalizovaná

Introduction

  • overview of SAS Foundation
  • course logistics
  • course data files

SAS Programs

  • introduction to SAS programs
  • submitting a SAS program
  • SAS program syntax

Accessing Data

  • examining SAS data sets
  • accessing SAS libraries

Producing Detail Reports

  • subsetting report data
  • sorting and grouping report data
  • enhancing reports

Formatting Data Values

  • using SAS formats
  • user-defined formats

Reading SAS Data Sets

  • reading a SAS data set
  • customizing a SAS data set

Reading Spreadsheet and Database Data

  • reading spreadsheet data
  • reading database data

Reading Raw Data Files

  • introduction to reading raw data files
  • reading standard delimited data
  • reading nonstandard delimited data
  • handling missing data

Manipulating Data

  • using SAS functions
  • conditional processing

Combining Data Sets

  • concatenating data sets
  • merging data sets one-to-one
  • merging data sets one-to-many
  • merging data sets with non-matches

Creating Summary Reports

  • FREQ procedure
  • MEANS and UNIVARIATE procedures
  • using the output delivery system

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

Data Transformations

  • introduction
  • manipulating character values
  • manipulating numeric values
  • converting variable type

Processing Data Iteratively

  • DO loop processing
  • conditional DO loop processing
  • SAS array processing
  • using SAS arrays

Introduction to the Macro Facility

  • 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 Programs

  • defining and calling a macro
  • macro parameters
  • macro conditional processing

Basic Queries

  • overview of the SQL procedure
  • specifying columns
  • specifying rows

Outputting Query Results

  • presenting data
  • creating tables
  • summarizing data

Subqueries and Joins

  • noncorrelated subqueries
  • inner joins