Base SAS 9 Programming - Programmeren (algemeen)

De Base SAS 9 Programming Training biedt een diepgaande introductie in het gebruik van SAS-software voor data-analyse en statistische modellering. Deze cursus is ideaal voor beginners en ervaren data-analisten die de basis van SAS willen begrijpen en ontwikkelen. De training behandelt fundamentele programmeerconcepten, waaronder het werken met SAS-datasets, data manipuleren en het uitvoeren van basisanalyses, en biedt een stevig fundament voor verdere SAS-gebaseerde analyse- en datavaardigheden.

Door deze training leer je:

• Basisstructuren en syntax van SAS-programmeren.
• Data importeren, reinigen en transformeren met behulp van SAS.
• Het uitvoeren van beschrijvende statistieken en eenvoudige analyses.
• Hoe je SAS-datasets beheert, zoals sorteren, samenvatten, en subsets maken.

De training bevat praktijkoefeningen en voorbeelden die aansluiten bij veelvoorkomende zakelijke toepassingen. De training wordt geleverd met een officiële proefexamen en een online mentor om je te ondersteunen bij het leerproces en je voor te bereiden op de certificering. Onze bekroonde e-learning zorgt voor een flexibele en effectieve leerervaring, waarmee je SAS-vaardigheden kunt ontwikkelen die direct toepasbaar zijn in het werkveld.

Waarom deze training?

De Base SAS 9 certificering is internationaal erkend en wordt zeer gewaardeerd in data-analyse- en business-intelligence-functies. Deze training helpt professionals om de expertise te ontwikkelen die nodig is om waardevolle inzichten te verkrijgen en succesvolle datagestuurde beslissingen te ondersteunen.

Cursusinhoud

SAS Overview

Course: 27 Minutes

• Course Introduction
• SAS Overview
• SAS Environments
• Obtaining and Installing a SAS environment
• SAS Interfaces
• Introducing SAS Programs
• Submitting a Program

SAS Studio

Course: 52 Minutes

• SAS Studio Overview
• SAS Studio Interface Elements
• SAS Studio Navigation Pane
• SAS Studio Code Tab
• SAS Studio Log Tab
• SAS Studio Results Tab
• SAS Studio Autocomplete
• Working with Tasks
• Working with Libraries

Practice: SAS Basics

Course: 3 Minutes

• Exercise: Running an SAS Program

SAS Data Sets

Course: 25 Minutes

• Course Introduction
• Data Set Descriptors
• Printing a Data Set
• Data Library Overview
• Using Data Libraries
• Assigning a Libref to a Relational Database
• Connecting to a Relational Database Source

Reading Data Sets

Course: 29 Minutes

• SAS Data Sources
• Using the DATA Statement to Create a Data Step
• Using the SET Statement for Data Step Processing
• Using the WHERE Statement to Subset Observations
• Using the DROP and KEEP Statements
• Adding Labels Using the LABEL Statement
• Adding Formats Using the FORMAT Statement

Reading from Excel

Course: 23 Minutes

• Creating a Data Set from an Excel Sheet
• Reading from an Excel Sheet
• Using the PROC Step to Create an Excel Sheet
• Using the ODS to Create an Excel Sheet
• Using the IMPORT Wizard with Excel
• Using the EXPORT Wizard with Excel

Reading Text Files

Course: 34 Minutes

• Creating a Data Set from a Delimited File
• Using the LENGTH Statement
• Reading Nonstandard Data with Informats
• Processing Nonstandard Data in the DATA Step
• Using the List Input DSD Option
• Using the MISSOVER Option

Practice: Work with Data

Course: 9 Minutes

• Exercise: Reading Data

Data Errors

Course: 18 Minutes

• Course Introduction
• Data Errors in Raw Data
• Validating and Cleaning Data
• Examining Data Errors
• Handling Data Errors

Data Validation and Cleaning

Course: 24 Minutes

• Validating Data Using PRINT and WHERE
• Validating Data Using FREQ and TABLES
• Validating Data Using MEANS and VAR
• Validating Data Using UNIVARIATE and VAR
• Cleaning Data At the Source
• Cleaning Data Using Assignment Statements
• Cleaning Data Using Conditionals in the DATA Step

Data Manipulation

Course: 22 Minutes

• Creating Variables with DATA Step Assignments
• Creating Values Using Operators and SAS Functions
• Executing Statements Conditionally
• Using the ELSE Statement in a Conditional
• Using IF and WHERE to Subset Observations
• Using IF-THEN DELETE to Subset Observations

Combining Data Sets

Course: 34 Minutes

• Combining SAS Data Sets
• Using APPEND to Combine Data Sets
• Using the FORCE Option to an APPEND Procedure
• Using SET in a DATA Step to Concatenate Data Sets
• Using RENAME to Change Variable Names
• Merging Data Sets One-To-One
• Merging Data Sets One-To-Many
• Merging Data Sets with Nonmatches

Practice: Validate, Clean, and Combine Data

Course: 9 Minutes

• Exercise: Validating, Cleaning, and Combining Data

Reports

Course: 40 Minutes

• Course Introduction
• Producing a Basic Report
• Producing an Enhanced Report in SAS
• Using the LABEL Statement to Add Column Headings
• Formatting Values Using the FORMAT Statement
• Creating and Applying User-defined Formats
• Subsetting and Grouping Reports Using WHERE and BY
• Directing Output Using ODS Statements
• Specifying Styles in an ODS Statement

Summary Reports

Course: 28 Minutes

• Creating Frequency Tables with the FREQ Procedure
• Creating Enhanced Frequency Tables
• Creating Summary Tables with the MEANS Procedure
• Creating Summary Tables with the SUMMARY Procedure
• Creating Enhanced Summary Tables
• Creating Tabular Reports with the TABULATE Procedure
• Creating Output Data Sets Using the OUT= Option

Graphics

Course: 21 Minutes

• Overview of SAS/GRAPH SG Procedures
• Creating Pie Charts with SAS/GRAPH SG Procedures
• Creating Bar Charts with SAS/GRAPH SG Procedures
• Creating Histograms with SAS/GRAPH SG Procedures
• Producing Scatter Plots with SAS/GRAPH SG Procedures

Practice: Reports and Charts

Course: 4 Minutes

• Exercise: Creating Reports and Charts

Input and Output

Course: 24 Minutes

• Course Introduction
• Outputting Multiple Observations
• Writing to Multiple SAS Data Sets
• Controlling Variable Input and Output
• Controlling Observation Input and Output

Data Summarization

Course: 16 Minutes

• Creating an Accumulating Variable Using RETAIN
• Creating an Accumulating Variable Using SUM
• Summarizing Data by Groups
• Summarizing Data by Multiple Groups

Read Raw Data

Course: 26 Minutes

• Using Column Input
• Using Formatted Input
• Creating a Single Observation from Multiple Records
• Controlling When a Record Loads
• Reading Raw Data with Missing Values

Data Transformation

Course: 45 Minutes

• Using SAS Functions
• Extracting and Transforming Character Values
• Separating and Concatenating Character Values
• Finding and Modifying Character Values
• Using Descriptive Statistics Functions
• Truncating Numeric Values
• Converting Values Between Data Types

Debugging

Course: 10 Minutes

• Debugging with PUTLOG
• Debugging Logic Errors

Practice: Data Manipulation

Course: 5 Minutes

• Exercise: Manipulating Data

Iterative DO Loops

Course: 21 Minutes

• Course Introduction
• Creating a Simple DO Loop
• DO WHILE Loops
• DO UNTIL Loops
• Nesting DO Loops
• Using a DO Loop to Reduce Redundant Code

SAS Arrays

Course: 25 Minutes

• SAS Array Overview
• Creating a SAS Array
• Processing a SAS Array
• Using SAS Arrays to Create Variables
• Using SAS Arrays to Perform Calculations
• Assigning Initial Values to an Array

Restructuring and Combining Data Sets

Course: 29 Minutes

• Using the TRANSPOSE Procedure to Manipulate Data
• Rotating a Data Set with the TRANSPOSE
• Match-Merging SAS Data Sets
• Manipulations with a Match-Merge
• Match-Merging Data Sets that Lack a Common Variable
• Match-Merging a SAS Data Set and an Excel Workbook
• Match-Merging Data Sets with Same-named Variables

Proc SQL

Course: 12 Minutes

• Proc SQL Overview
• Querying with Proc SQL
• Joining Tables with Proc SQL

Practice: Array Processing & Merges

Course: 6 Minutes

• Exercise: Processing an Array & Merging Data Sets

Specificaties

Taal: Engels
Kwalificaties van de Instructeur: Gecertificeerd
Cursusformaat en Lengte: Lesvideo's met ondertiteling, interactieve elementen en opdrachten en testen
Lesduur: 10:08 uur
Voortgangsbewaking: Ja
Toegang tot Materiaal: 365 dagen
Technische Vereisten: Computer of mobiel apparaat, Stabiele internetverbindingen Webbrowserzoals Chrome, Firefox, Safari of Edge.
Support of Ondersteuning: Helpdesk en online kennisbank 24/7
Certificering: Certificaat van deelname in PDF formaat
Prijs en Kosten: Cursusprijs zonder extra kosten
Annuleringsbeleid en Geld-Terug-Garantie: Wij beoordelen dit per situatie
Award Winning E-learning: Ja

Tip! Zorg voor een rustige leeromgeving, tijd en motivatie, audioapparatuur zoals een koptelefoon of luidsprekers voor audio, accountinformatie zoals inloggegevens voor toegang tot het e-learning platform.