
Base SAS 9 Programming elearning bundle
Course ID: 271302 view dates
Font size: 
Description:
This is a bundled training package. It contains training for each of the bundled items below:
Bundle Price: $229.00
Total Savings: $220.70
Base SAS 9 Programming: Creating Reports
Creating reports, visualization, and charts from your data adds immediate impact, and can allow your audience to glean information quickly and effectively. This course covers reporting in SAS, and how to create impactful graphics. It is one of a series that prepares you for the SAS certification exam, SAS Certified Base Programmer for SAS 9.
Learning Objectives
Learning Objectives
 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 userdefined 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 oneway and twoway 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 onedimensional, twodimensional, and threedimensional 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
Effectively getting data into and out of SAS is key for a SAS programmer. Data will come in a variety of formats, and different output formats will be required. This course covers inputs and outputs from the SAS system. It also covers various functions for data transformation, and some methods for debugging your programs. This course is one of a series that prepares you for the SAS certification exam, SAS Certified Base Programmer for SAS 9.
Learning Objectives
Learning Objectives
 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 BYGroup processing in SAS
 Summarize data by multiple groups using BYGroup 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 linehold 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: Introduction to Data Sets
SAS data sets are collections of data that SAS creates and can process, and understanding their structure and utility is key to grasping the power of Base SAS. This course covers the basics of data sets, and how to create them from various sources. This course is one of a series that prepares you for the SAS certification exam, SAS Certified Base Programmer for SAS 9.
Learning Objectives
Learning Objectives
 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 twolevel 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
Manipulating data sets is a big part of mastering SAS, and often the data you want to work with is not clean, containing errors or missing data. This course covers handling data errors, and validating and cleaning data. It goes on to cover further manipulation of data sets, including merging and combining sets. This course is one of a series that prepares you for the SAS certification exam, SAS Certified Base Programmer for SAS 9.
Learning Objectives
Learning Objectives
 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 IFTHEN 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 IFTHEN statement and the IFTHEN DO statement to execute statements conditionally in SAS
 Use the ELSE statement to execute alternative actions in an IFTHEN statement in SAS
 Use the subsetting IF statement and the WHERE statement to subset observations in SAS
 Use the IFTHEN 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 onetoone based on a common variable using MERGE and BY statements in a DATA step
 Merge SAS data sets onetomany 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: The SAS Environment
There is a variety of SAS environments available to you as a SAS programmer, and the one you use will depend on the underlying SAS system. This course introduces SAS and the various systems including the SAS Studio web interface and SAS Windowing Environment. This course is one of a series that prepares you for the SAS certification exam, SAS Certified Base Programmer for SAS 9.
Learning Objectives
Learning Objectives
 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: Data Structures
Combining loops and arrays opens up some of the more powerful features of SAS programming. This course covers various do loop types, and introduces arrays in SAS. It goes on to cover further techniques for restructuring and combining data including match merges. Finally, it takes a brief look at SQL database connectivity in SAS. This course is one of a series that prepares you for the SAS certification exam, SAS Certified Base Programmer for SAS 9.
Learning Objectives
Learning Objectives
 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 matchmerge on SAS data sets
 Control a matchmerge 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 matchmerge a SAS data set with an Excel workbook
 Use RENAME to matchmerge data sets with samenamed 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
Register Now
Base SAS 9 Programming elearning bundle
 Course ID:
271302  Duration:
n/a  Price:
$229