Home » Base SAS 9 Programming

Opleiding: Base SAS 9 Programming

Bij: OEM Office Elearning Menu

 

OEM Office Elearning Menu

P.J, Oudweg 4
1314 CH ALMERE
 

Inhoud van de cursus

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 omissionretention 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 enate twomore 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 enation
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 columnsfixed 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 transformscalculations 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

Toelatingseisen: wat heb je nodig?

Er is geen specifieke voorkennis vereist.

Duur van de cursus

16 uur

Bijzonderheden

Award Winning E-learning

Plaatsen / leslocaties

Heel Nederland, E-learning, Online

Algemene informatie over de cursus

Bestel deze geweldige E-learning Training Base SAS 9 Programming online, 1 jaar 24/ 7 toegang tot rijke interactieve video’s, spraak, praktijkopdrachten, voortgangsbewaking door rapportages en testen per onderwerp om de kennis direct te toetsen. Na de cursus ontvangt u een certificaat van deelname.

SAS is een systeem van geļntegreerde softwareoplossingen voor het beheren en analyseren van gegevens. De kern van het systeem is Base SAS, een programmeertaal die is ontworpen voor gegevensmanipulatie, informatieopslag en ophalen, statistische analyse en rapportage. Deze reeks Skillsoft-cursussen omvat het schrijven van goedgevormde programma's in Base SAS 9, programmatisch manipuleren van gegevens en het genereren van rapporten. Het pad omvat ook de doelstellingen voor het certificeringsexamen, SAS Certified Base Programmer voor SAS 9.

Duur: 16 uur
Taal: Engels
Certificaat van deelname: Ja
Online toegang: 365 dagen
Voortgangsbewaking: Ja
Award Winning E-learning: Ja
Geschikt voor mobiel: Ja

Informatie aanvragen

Gegevens aangeduid met een * zijn verplicht in te vullen.
jaar
 
resterend: tekens
 
Be41E Typ de code exact over: (hoofdlettergevoelig)
 
© Copyright 2009-2020 Particuliereopleidingen.nl | Algemene voorwaarden | Overzicht van onze aanbieders | Adverteren