Snel navigeren naar:

  • Inhoud
  • Voordelen
  • Specificaties
  • Reviews
  • More information
  • FAQ

Productinformatie

In deze cursus maakt u kennis met de programmeertaal SAS. U krijgt een korte introductie over SAS, u maakt kennis met de SAS omgeving, de basis van data sets, handling data errors en het opschonen en valideren van data. Daarnaast maakt u kennis met een aantal geavanceerde functionaliteiten zoals het ontwikkelen van rapporten en grafieken in SAS, verschillende functies van data transformatie en methodes om te debuggen.

Tevens bent u optimaal voorbereid op de officiële certificering SAS Certified Base Programmer for SAS 9.

Inhoud van de training

Base SAS 9 Programming

16 uur

Base SAS 9 Programming: The SAS Environment

  • start the course
  • describe the purpose of SAS programming
  • describe the various SAS environments used for SAS programming
  • describe ways in which a SAS environment is obtained
  • list the attributes of the three main interfaces to SAS – SAS Studio, SAS Enterprise Guide, and SAS Windowing Environment
  • create a simple SAS program
  • run a simple SAS program
  • list the characteristics of the SAS Studio environment
  • list SAS Studio interface elements
  • use the SAS Studio navigation pane
  • use the SAS Studio Code Tab
  • use the SAS Studio Log Tab
  • use the SAS Studio Results Tab
  • work with autocomplete in SAS Studio
  • work with tasks in SAS Studio
  • work with libraries in SAS Studio
  • create and run a simple SAS program in one of the SAS environments

Base SAS 9 Programming: Introduction to Data Sets

  • start the course
  • describe the components of a SAS data set
  • use the CONTENTS procedure to view a data set descriptor, and the PRINT procedure to display the data
  • describe SAS libraries, including temporary and permanent libraries
  • browse a SAS library using the SAS Explorer and the CONTENTS procedure
  • use the LIBNAME statement to assign a library reference name to a relational database in SAS
  • reference a relational database table using a SAS two-level name
  • describe different scenarios for reading from a data source in SAS
  • use the DATA statement to begin a data step in SAS
  • use the SET statement to read observations from a SAS data set
  • use the WHERE statement with conditionals to subset an observation in SAS
  • use the DROP and KEEP statements to specify variables for omission or retention in a SAS data set
  • use the LABEL statement to add labels to the descriptor portion of a SAS data set
  • use the FORMAT statement to add formats to the descriptor portion of a SAS data set
  • create a data set from an Excel sheet using the PROC step in SAS
  • read from an Excel sheet using the libname statement
  • use the PROC step to create an Excel sheet in SAS
  • use the ODS to create an Excel sheet in SAS
  • use the IMPORT wizard to import data from an Excel sheet in SAS
  • use the EXPORT wizard to write to an Excel Sheet in SAS
  • create a data set from a delimited raw data file using the DATA step in SAS
  • use the LENGTH statement to define the length of a variable in SAS
  • read nonstandard data in SAS using informants
  • use additional SAS statements to process nonstandard data in the DATA step
  • read consecutive delimiters as missing values using the DSD option in SAS
  • recognize missing data at the end of a record with the MISSOVER option
  • read data from a variety of sources in SAS

Base SAS 9 Programming: Working with Data Sets

  • start the course
  • describe how SAS handles errors in raw data files
  • describe procedures and techniques for validating and cleaning data in SAS
  • use the SAS log to examine data errors
  • use conditionals to handle data errors in SAS
  • use the PRINT procedure with the WHERE statement to validate data in SAS
  • use the FREQ procedure with the TABLES statement to validate data in SAS
  • use the MEANS procedure with the VAR statement to validate data in SAS
  • use the UNIVARIATE procedure with the VAR statement to validate data in SAS
  • open the source data to clean data for SAS
  • use assignment statements in the DATA step to clean data in SAS
  • use IF-THEN and ELSE statements in the DATA step to clean data in SAS
  • use the assignment statement in the DATA step to create variables in SAS
  • use operators, including SAS functions, to create data values
  • use the IF-THEN statement and the IF-THEN DO statement to execute statements conditionally in SAS
  • use the ELSE statement to execute alternative actions in an IF-THEN statement in SAS
  • use the subsetting IF statement and the WHERE statement to subset observations in SAS
  • use the IF-THEN DELETE statement to subset observations in SAS
  • describe the methods for combining data sets in SAS
  • use the APPEND procedure to append a SAS data set to another SAS data set
  • use the FORCE option with the APPEND procedure to append one SAS data set to another SAS data set
  • use the SET statement in a DATA step to concatenate two or more SAS data sets
  • use the RENAME= data set option to change the names of variables in SAS
  • merge SAS data sets one-to-one based on a common variable using MERGE and BY statements in a DATA step
  • merge SAS data sets one-to-many based on a common variable using MERGE and BY statements in a DATA step
  • use the IN= option to control the observations in the output SAS data set
  • validate and clean data sets and combine them with an append operation and a concatenation

Base SAS 9 Programming: Creating Reports

  • start the course
  • create a basic report in SAS
  • create an enhanced report using SAS system options, and by adding titles and footnotes
  • add column headings to a report using LABEL statements
  • create formatted output by using the FORMAT statement
  • use the FORMAT procedure to create user-defined formats, and apply them to variables in reports
  • use the WHERE and BY statements to subset and group a report
  • use ODS statements to direct output to various ODS destinations
  • specify a style definition using a STYLE= option in the ODS destination statement in SAS
  • use the FREQ procedure to create one-way and two-way frequency tables in SAS
  • use various options to enhance frequency tables in SAS
  • use the MEANS procedure to create summary statistics and multilevel summaries in SAS
  • use the SUMMARY procedure to create summaries in SAS
  • use various options to enhance summary tables in SAS
  • use the TABULATE procedure to create one-dimensional, two-dimensional, and three-dimensional tabular reports
  • use the OUT= option in the TABULATE procedure to produce output data sets
  • describe the capabilities of the SAS/GRAPH statistical graphics procedures
  • create pie charts using the SAS/GRAPH statistical graphics procedures
  • create bar charts using the SAS/GRAPH statistical graphics procedures
  • create histogram charts SAS/GRAPH statistical graphics procedures
  • create scatter plots using SAS/GRAPH statistical graphics procedures
  • create and chart a summary report and a frequency table in SAS

Base SAS 9 Programming: Inputs and Outputs

  • start the course
  • control when SAS writes an observation to a data set using an OUTPUT statement
  • write to more than one SAS data set
  • control SAS variable input and output with DROP and KEEP
  • control SAS observation input and output with OBS and FIRSTOBS
  • use the RETAIN statement to create an accumulating variable in SAS
  • use the SUM statement to create an accumulating variable in SAS
  • summarize data by groups using BY-Group processing in SAS
  • summarize data by multiple groups using BY-Group processing in SAS
  • use column input to read input data that is arranged in columns or fixed fields in SAS
  • use formatted input to read both standard and nonstandard data that is arranged in fixed fields in SAS
  • use multiple INPUT statements to read a group of records in a raw data file as a single observation in a new data set in SAS
  • use a line-hold specifier to prevent the second INPUT statement in a DATA step from moving to the second line in a raw data file in SAS
  • using the MISSOVER and DSD options to control behavior with missing values in raw data in SAS
  • use various SAS functions to perform transforms or calculations on variables
  • use SAS functions to extract and transform character values, including SUBSTR, LEFT, RIGHT, CHAR, PROPCASE and LENGTH
  • create pie charts using the SAS/GRAPH Statistical Graphics Procedures
  • use SAS functions to find and modify character values, including FIND, SUBSTR, COMPRESS and TRAINED
  • use descriptive SAS statistical functions, such as SUM, MIN, MAX and MEAN
  • truncate numerical SAS values by using the ROUND, INT, FLOOR, and CEIL functions
  • convert between SAS data types using INPUT and PUT functions
  • debug SAS programs using the PUTLOG statement
  • debug logic errors in SAS programs
  • create a program that manipulates input data

Base SAS 9 Programming: Data Structures

  • start the course
  • create a simple DO loop in SAS
  • create a DO WHILE loop in SAS
  • create a DO UNTIL loop in SAS
  • create a nested DO loop in SAS
  • reduce redundant code in a SAS program by creating a DO loop
  • describe the characteristics of arrays in SAS
  • create an array in SAS
  • process all the elements of an array in a SAS program
  • create variables in an array in SAS
  • perform calculations using arrays and the keyword OF in SAS
  • assign initial values in an ARRAY statement in SAS
  • use the TRANSPOSE procedure to manipulate data sets in SAS
  • use the TRANSPOSE procedure to rotate data sets in SAS
  • perform a match-merge on SAS data sets
  • control a match-merge with OUTPUT, DROP, KEEP, FIRST and LAST
  • merge data sets with no common variable by using a series of separate DATA steps
  • use SAS/ACCESS LIBNAME to match-merge a SAS data set with an Excel workbook
  • use RENAME to match-merge data sets with same-named variables
  • describe PROC SQL and use it to connect to a data set
  • use PROC SQL to query a table in SAS
  • use PROC SQL to join tables in SAS
  • create and process an array and merge data sets in SAS

Kenmerken

Engels (US)
16 uur
Software Developer
90 dagen online toegang
HBO

Meer informatie

Extra product informatie 0
Doelgroep Softwareontwikkelaar
Voorkennis

U heeft basiskennis van programmeren.

resultaat

Na succesvolle afronding bent u bekend met de programmeertaal SAS en bent u tevens optimaal voorbereid op de officiële certificering SAS Certified Base Programmer for SAS 9.

Positieve reacties van cursisten

Ontwikkel je tot data analist

Service is echt heel goed. Snel, klantvriendelijk, weten waar ze over praten en denken met je mee met oplossingen. Daarnaast hebben ze ook een goed leerplatform om je studie te volgen en na elke module een korte toets om te zien hoeveel je ervan heb begrepen en je kan de status zien hoeveel tijd je hebt besteed aan je studie. Ik waardeer ze enorm en ik raad elke ICT'er aan om met hen in zee te gaan om je studie te volgen.

- Emilio Jones

Training: Introduction to SQL

Eén training geprobeerd en deze naar tevredenheid gevolgd. Een module werkte in eerste instantie niet, maar na contact opgenomen te hebben met klantenservice kreeg ik snel antwoord met een oplossing.

- Lars van der Spek

Training: Certified Ethical Hacker (CEHv12) - incl. examen

Eerste keer dat ik een online training heb gedaan en zou zo weer een training volgen via icttraningen.nl

- Jerry Jialal

Training: Microsoft Managing Modern Desktops (exam MD-101)

Het resultaat van de groep is absoluut bevredigend. Ik ga in ieder geval geen ander meer bellen.

- Antoine Evertze, Sales Engineer bij Chubb

Training: PRINCE2® 6e editie Foundation- incl. examen

Als er wat is staan ze altijd voor me klaar. Ik word meteen geholpen als ik bel.

- E. Zeijlmans, P&O adviseur bij Parnassia Groep

Training: ITIL® 4 Foundation - incl. examen

Wij zijn gebaat bij mensen die bijblijven in hun vakgebied en continu getriggerd worden.

- W. van Uijthoven, IT manager bij gemeente Arnhem

Training: Excel 2013 Compleet

Ik heb al eens eerder een training gehad via icttrainingen.nl en dat was een erg leerzame, leuke ervaring. Nu heb ik via het werk een online cursus en deze lijkt tot nu toe ook erg leerzaam.

- Michelle Brierley

Hoe gaat het te werk?

1

Training bestellen

Nadat je de training hebt besteld krijg je bevestiging per e-mail.

2

Toegang leerplatform

In de e-mail staat een link waarmee je toegang krijgt tot ons leerplatform.

3

Direct beginnen

Je kunt direct van start. Studeer vanaf nu waar en wanneer jij wilt.

4

Training afronden

Rond de training succesvol af en ontvang van ons een certificaat!

Veelgestelde vragen

Veelgestelde vragen

Op welke manieren kan ik betalen?

Je kunt bij ons betalen met iDEAL, PayPal, Creditcard, Bancontact en op factuur. Betaal je op factuur, dan kun je met de training starten zodra de betaling binnen is.

Hoe lang heb ik toegang tot de training?

Dit verschilt per training, maar meestal 180 dagen. Je kunt dit vinden onder het kopje ‘Kenmerken’.

Waar kan ik terecht als ik vragen heb?

Je kunt onze Learning & Development collega’s tijdens kantoortijden altijd bereiken via support@icttrainingen.nl of telefonisch via 026-8402941.

Background Frame
Background Frame

Onbeperkt leren

Met ons Unlimited concept kun je onbeperkt gebruikmaken van de trainingen op de website voor een vast bedrag per maand.

Bekijk de voordelen

Heb je nog twijfels?

Of gewoon een vraag over de training? Blijf er vooral niet mee zitten. We helpen je graag verder. Daar zijn we voor!

Contactopties