-
SAS Programming Essentials: Printing a Data Set
After watching this video, you will be able to use the CONTENTS procedure to view a data set descriptor, and the PRINT procedure to display the data.
-
SAS Programming Essentials: Data Set Descriptors
After watching this video, you will be able to describe the components of a SAS data set.
-
SAS Programming Essentials: Running an SAS Program
After watching this video, you will be able to create and run a simple SAS program in one of the SAS environments.
-
SAS Programming Essentials: Working with Libraries
After watching this video, you will be able to work with libraries in SAS Studio.
-
SAS Programming Essentials: Working with Tasks
After watching this video, you will be able to work with tasks in SAS Studio.
-
SAS Programming Essentials: Creating a Data Set from a Delimited File
After watching this video, you will be able to create a data set from a delimited raw data file using the DATA step in SAS.
-
SAS Programming Essentials: Using the EXPORT Wizard with Excel
After watching this video, you will be able to use the EXPORT wizard to write to an Excel Sheet in SAS.
-
SAS Programming Essentials: Using the IMPORT wizard with Excel
After watching this video, you will be able to use the IMPORT wizard to import data from an Excel sheet in SAS.
-
SAS Programming Essentials: Using the List Input DSD Option
After watching this video, you will be able to read consecutive delimiters as missing values using the DSD option in SAS.
-
SAS Programming Essentials: Processing Nonstandard Data in the DATA Step
After watching this video, you will be able to use additional SAS statements to process nonstandard data in the DATA step.
-
SAS Programming Essentials: Reading Nonstandard Data with Informats
After watching this video, you will be able to read nonstandard data in SAS using informats.
-
SAS Programming Essentials: Using the LENGTH Statement
After watching this video, you will be able to use the LENGTH statement to define the length of a variable in SAS.
-
SAS Programming Essentials: Using the ODS to Create an Excel Sheet
After watching this video, you will be able to use the ODS to create an Excel sheet in SAS.
-
SAS Programming Essentials: Using the PROC step to Create an Excel Sheet
After watching this video, you will be able to use the PROC step to create an Excel sheet in SAS.
-
SAS Programming Essentials: Reading from an Excel Sheet
After watching this video, you will be able to read from an Excel sheet using the libname statement.
-
SAS Programming Essentials: Creating a Data Set from an Excel Sheet
After watching this video, you will be able to create a data set from an Excel sheet using the PROC step in SAS.
-
SAS Programming Essentials: Using the SET Statement for Data Step Processing
After watching this video, you will be able to use the SET statement to read observations from a SAS data set.
-
SAS Programming Essentials: Using the DATA Statement to Create a Data Step
After watching this video, you will be able to use the DATA statement to begin a data step in SAS.
-
SAS Programming Essentials: Adding Formats Using the FORMAT Statement
After watching this video, you will be able to use the FORMAT statement to add formats to the descriptor portion of a SAS data set.
-
SAS Programming Essentials: Adding Labels Using the LABEL Statement
After watching this video, you will be able to use the LABEL statement to add labels to the descriptor portion of a SAS data set.
-
SAS Programming Essentials: Using the DROP and KEEP Statements
After watching this video, you will be able to use the DROP and KEEP statements to specify variables for omission or retention in a SAS data set.
-
SAS Programming Essentials: Using the WHERE Statement to Subset Observations
After watching this video, you will be able to use the WHERE statement with conditionals to subset an observation in SAS.
-
SAS Programming Essentials: Connecting to a Relational Database Source
After watching this video, you will be able to reference a relational database table using a SAS two-level name.
-
SAS Programming Essentials: Assigning a Libref to a Relational Database
After watching this video, you will be able to use the LIBNAME statement to assign a library reference name to a relational database in SAS.
-
SAS Programming Essentials: Using Data Libraries
After watching this video, you will be able to browse a SAS library using the SAS Explorer and the CONTENTS procedure.
-
SAS Programming Essentials: Data Library Overview
After watching this video, you will be able to describe SAS libraries, including temporary and permanent libraries.
-
SAS Programming Essentials: SAS Data Sources
After watching this video, you will be able to describe different scenarios for reading from a data source in SAS.
-
SAS Programming Essentials: Using IF and WHERE to Subset Observations
After watching this video, you will be able to use the subsetting IF statement and the WHERE statement to subset observations in SAS.
-
SAS Programming Essentials: Using the ELSE Statement in a Conditional
After watching this video, you will be able to use the ELSE statement to execute alternative actions in an IF-THEN statement in SAS.
-
SAS Programming Essentials: Executing Statements Conditionally
After watching this video, you will be able to use the IF-THEN statement and the IF-THEN DO statement to execute statements conditionally in SAS.
-
SAS Programming Essentials: Creating Values using Operators and SAS Functions
After watching this video, you will be able to use operators, including SAS functions, to create data values.
-
SAS Programming Essentials: Using the FORCE option to an APPEND Procedure
After watching this video, you will be able to use the FORCE option with the APPEND procedure to append one SAS data set to another SAS data set.
-
SAS Programming Essentials: Using APPEND to Combine Data Sets
After watching this video, you will be able to use the APPEND procedure to append a SAS data set to another SAS data set.
-
SAS Programming Essentials: Combining SAS Data Sets
After watching this video, you will be able to describe the methods for combining data sets in SAS.
-
SAS Programming Essentials: Using IF-THEN DELETE to Subset Observations
After watching this video, you will be able to use the IF-THEN DELETE statement to subset observations in SAS.
-
SAS Programming Essentials: Creating Variables with DATA Step Assignments
After watching this video, you will be able to use the assignment statement in the DATA step to create variables in SAS.
-
SAS Programming Essentials: Cleaning Data Using Conditionals in the DATA Step
After watching this video, you will be able to use IF-THEN and ELSE statements in the DATA step to clean data in SAS.
-
SAS Programming Essentials: Cleaning Data Using Assignment Statements
After watching this video, you will be able to use assignment statements in the DATA step to clean data in SAS.
-
SAS Programming Essentials: Validating Data Using PRINT and WHERE
After watching this video, you will be able to use the PRINT procedure with the WHERE statement to validate data in SAS.
-
SAS Programming Essentials: Handling Data Errors
After watching this video, you will be able to use conditionals to handle data errors in SAS.
-
SAS Programming Essentials: Examining Data Errors
After watching this video, you will be able to use the SAS log to examine data errors.
-
SAS Programming Essentials: Validating and Cleaning Data
After watching this video, you will be able to describe procedures and techniques for validating and cleaning data in SAS.
-
SAS Programming Essentials: Cleaning Data Using the Viewtable Window
After watching this video, you will be able to use the Viewtable window to clean data in SAS.
-
SAS Programming Essentials: Validating Data Using UNIVARIATE and VAR
After watching this video, you will be able to use the UNIVARIATE procedure with the VAR statement to validate data in SAS.
-
SAS Programming Essentials: Validating Data Using MEANS and VAR
After watching this video, you will be able to use the MEANS procedure with the VAR statement to validate data in SAS.
-
SAS Programming Essentials: Validating Data Using FREQ and TABLES
After watching this video, you will be able to use the FREQ procedure with the TABLES statement to validate data in SAS.
-
SAS Programming Essentials: Data Errors in Raw Data
After watching this video, you will be able to define types of errors in raw data files in SAS.
-
SAS Programming Essentials: Reading Data
After watching this video, you will be able to read data from a variety of sources in SAS.
-
SAS Programming Essentials: Using the MISSOVER Option
After watching this video, you will be able to recognize missing data at the end of a record with the MISSOVER option.
-
SAS Programming Essentials: SAS Studio Results Tab
After watching this video, you will be able to work with autocomplete in SAS Studio.
-
SAS Programming Essentials: SAS Studio Results Tab
After watching this video, you will be able to use the SAS Studio Results Tab.
-
SAS Programming Essentials: SAS Studio Log Tab
After watching this video, you will be able to use the SAS Studio Log Tab.
-
SAS Programming Essentials: SAS Studio Code Tab
After watching this video, you will be able to use the SAS Studio Code Tab.
-
SAS Programming Essentials: Introducing SAS Programs
After watching this video, you will be able to create a simple SAS program.
-
SAS Programming Essentials: SAS Interfaces
After watching this video, you will be able to list the attributes of the three main interfaces to SAS – SAS Studio, SAS Enterprise Guide, and SAS Windowing Environment.
-
SAS Programming Essentials: SAS Studio Navigation Pane
After watching this video, you will be able to use the SAS Studio navigation pane.
-
SAS Programming Essentials: SAS Studio Interface Elements
After watching this video, you will be able to list SAS Studio interface elements.
-
SAS Programming Essentials: SAS Studio Overview
After watching this video, you will be able to list the characteristics of the SAS Studio environment.
-
SAS Programming Essentials: Submitting a Program
After watching this video, you will be able to run a simple SAS program.
-
SAS Programming Essentials: SAS Environments
After watching this video, you will be able to describe the various SAS environments used for SAS programming.
-
SAS Programming Essentials: SAS Overview
After watching this video, you will be able to describe the purpose of SAS programming.
-
SAS Programming Essentials: Obtaining and Installing a SAS environment
After watching this video, you will be able to describe ways in which a SAS environment is obtained.
-
SAS Programming Essentials: Using a DO Loop to Reduce Redundant Code
After watching this video, you will be able to reduce redundant code in a SAS program by creating a DO loop.
-
SAS Programming Essentials: Nesting DO Loops
After watching this video, you will be able to create a nested DO loop in SAS.
-
SAS Programming Essentials: Do UNTIL Loops
After watching this video, you will be able to create a DO UNTIL loop in SAS.
-
SAS Programming Essentials: DO WHILE Loops
After watching this video, you will be able to create a DO WHILE loop in SAS.
-
SAS Programming Essentials: Debugging with PUTLOG
After watching this video, you will be able to debug SAS programs using the PUTLOG statement.
-
SAS Programming Essentials: Converting Values Between Data Types
After watching this video, you will be able to convert between SAS data types using INPUT and PUT functions.
-
SAS Programming Essentials: Truncating Numeric Values
After watching this video, you will be able to truncate numerical SAS values by using the ROUND, INT, FLOOR, and CEIL functions.
-
SAS Programming Essentials: Using Descriptive Statistics Functions
After watching this video, you will be able to use descriptive SAS statistical functions, such as SUM, MIN, MAX and MEAN.
-
SAS Programming Essentials: Creating a Simple DO Loop
After watching this video, you will be able to create a simple DO loop in SAS.
-
SAS Programming Essentials: Manipulating Data
After watching this video, you will be able to create a program that manipulates input data.
-
SAS Programming Essentials: Debugging logic errors
After watching this video, you will be able to debug logic errors in SAS programs.
-
SAS Programming Essentials: Finding and Modifying Character Values
After watching this video, you will be able to use SAS functions to find and modify character values, including FIND, SUBSTR, COMPRESS and TRANWRD.
-
SAS Programming Essentials: Separating and Concatenating Character Values
After watching this video, you will be able to use SAS functions to separate and concatenate character values, including TRIM, STRIP, SCAN, CAT, CATT, CATS, CATX, and ||.
-
SAS Programming Essentials: Extracting and Transforming Character Values
After watching this video, you will be able to use SAS functions to extract and transform character values, including SUBSTR, LEFT, RIGHT, CHAR, PROPCASE and LENGTH.
-
SAS Programming Essentials: Processing an Array & Merging Data Sets
After watching this video, you will be able to create and process an array and merge data sets in SAS.
-
SAS Programming Essentials: Querying with PROC SQL
After watching this video, you will be able to use PROC SQL to query a table in SAS.
-
SAS Programming Essentials: PROC SQL Overview
After watching this video, you will be able to describe PROC SQL and use it to connect to a data set.
-
SAS Programming Essentials: Match-Merging Data Sets with Same-named Variables
After watching this video, you will be able to use RENAME to match-merge data sets with same-named variables.
-
SAS Programming Essentials: Match-Merging a SAS Data Set and an Excel Workbook
After watching this video, you will be able to use SAS/ACCESS LIBNAME to match-merge a SAS data set with an Excel workbook.
-
SAS Programming Essentials: Joining Tables with PROC SQL
After watching this video, you will be able to use PROC SQL to join tables in SAS.
-
SAS Programming Essentials: Using the TRANSPOSE Procedure to Manipulate Data
After watching this video, you will be able to use the TRANSPOSE procedure to manipulate data sets in SAS.
-
SAS Programming Essentials: Match-Merging Data Sets That Lack a Common Variable
After watching this video, you will be able to merge data sets with no common variable by using a series of separate DATA steps.
-
SAS Programming Essentials: Manipulations with a Match-Merge
After watching this video, you will be able to control a match-merge with OUTPUT, DROP, KEEP, FIRST and LAST.
-
SAS Programming Essentials: Match-Merging SAS Data Sets
After watching this video, you will be able to perform a match-merge on SAS data sets.
-
SAS Programming Essentials: Rotating a Data Set with the TRANSPOSE
After watching this video, you will be able to use the TRANSPOSE procedure to rotate data sets in SAS.
-
SAS Programming Essentials: Using SAS Arrays to Create Variables
After watching this video, you will be able to create variables in an array in SAS.
-
SAS Programming Essentials: Processing a SAS Array
After watching this video, you will be able to process all the elements of an array in a SAS program.
-
SAS Programming Essentials: Creating a SAS Array
After watching this video, you will be able to create an array in SAS.
-
SAS Programming Essentials: SAS Array Overview
After watching this video, you will be able to describe the characteristics of arrays in SAS.
-
SAS Programming Essentials: Assigning Initial Values to an Array
After watching this video, you will be able to assign initial values in an ARRAY statement in SAS.
-
SAS Programming Essentials: Using SAS Arrays to Perform Calculations
After watching this video, you will be able to perform calculations using arrays and the keyword OF in SAS.
-
SAS Programming Essentials: Creating Summary Tables with the SUMMARY Procedure
After watching this video, you will be able to use the SUMMARY procedure to create summaries in SAS.
-
SAS Programming Essentials: Creating Summary Tables with the MEANS Procedure
After watching this video, you will be able to use the MEANS procedure to create summary statistics and multilevel summaries in SAS.
-
SAS Programming Essentials: Creating Enhanced Frequency Tables
After watching this video, you will be able to use various options to enhance frequency tables in SAS.
-
SAS Programming Essentials: Creating Frequency Tables with the FREQ Procedure
After watching this video, you will be able to use the FREQ procedure to create one-way and two-way frequency tables in SAS.
-
SAS Programming Essentials: Creating Output Data Sets Using the OUT= Option
After watching this video, you will be able to use the OUT= option in the TABULATE procedure to produce output data sets.
-
SAS Programming Essentials: Creating Tabular Reports with the TABULATE Procedure
After watching this video, you will be able to use the TABULATE procedure to create one-dimensional, two-dimensional, and three-dimensional tabular reports.
-
SAS Programming Essentials: Creating Enhanced Summary Tables
After watching this video, you will be able to use various options to enhance summary tables in SAS.
-
SAS Programming Essentials: Specifying Styles in an ODS Statement
After watching this video, you will be able to specify a style definition using a STYLE= option in the ODS destination statement in SAS.
-
SAS Programming Essentials: Directing Output Using ODS Statements
After watching this video, you will be able to use ODS statements to direct output to various ODS destinations.
-
SAS Programming Essentials: Subsetting and Grouping Reports Using WHERE and BY
After watching this video, you will be able to use the WHERE and BY statements to subset and group a report.
-
SAS Programming Essentials: Producing a Basic Report
After watching this video, you will be able to create a basic report in SAS.
-
SAS Programming Essentials: Validating and Combining Data
After watching this video, you will be able to validate data sets and combine them with an append operation and a concatenation.
-
SAS Programming Essentials: Merging Data Sets with Nonmatches
After watching this video, you will be able to use the IN= option to control the observations in the output SAS data set.
-
SAS Programming Essentials: Merging Data Sets One-To-Many
After watching this video, you will be able to merge SAS data sets one-to-many based on a common variable using MERGE and BY statements in a DATA step.
-
SAS Programming Essentials: Creating and Applying User-defined Formats
After watching this video, you will be able to use the FORMAT procedure to create user-defined formats, and apply them to variables in reports.
-
SAS Programming Essentials: Formatting Values Using the FORMAT Statement
After watching this video, you will be able to create formatted output by using the FORMAT statement.
-
SAS Programming Essentials: Using the LABEL Statement to Add Column Headings
After watching this video, you will be able to add column headings to a report using LABEL statements.
-
SAS Programming Essentials: Producing an Enhanced Report in SAS
After watching this video, you will be able to create an enhanced report using SAS system options, and by adding titles and footnotes.
-
SAS Programming Essentials: Merging Data Sets One-To-One
After watching this video, you will be able to merge SAS data sets one-to-one based on a common variable using MERGE and BY statements in a DATA step.
-
SAS Programming Essentials: Using RENAME to Change Variable Names
After watching this video, you will be able to use the RENAME= data set option to change the names of variables in SAS.
-
SAS Programming Essentials: Using SET in a DATA Step to Concatenate Data Sets
After watching this video, you will be able to use the SET statement in a DATA step to concatenate two or more SAS data sets.
-
SAS Programming Essentials: Reading Raw Data with Missing Values
After watching this video, you will be able to using the MISSOVER and DSD options to control behavior with missing values in raw data in SAS.
-
SAS Programming Essentials: Controlling When a Record Loads
After watching this video, you will be able to 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.
-
SAS Programming Essentials: Creating a Single Observation from Multiple Records
After watching this video, you will be able to 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.
-
SAS Programming Essentials: Using Formatted Input
After watching this video, you will be able to use formatted input to read both standard and nonstandard data that is arranged in fixed fields in SAS.
-
SAS Programming Essentials: Using SAS Functions
After watching this video, you will be able to use various SAS functions to perform transforms or calculations on variables.
-
SAS Programming Essentials: Creating an Accumulating Variable Using RETAIN
After watching this video, you will be able to use the RETAIN statement to create an accumulating variable in SAS.
-
SAS Programming Essentials: Using Column Input
After watching this video, you will be able to use column input to read input data that is arranged in columns or fixed fields in SAS.
-
SAS Programming Essentials: Summarizing Data by Multiple Groups
After watching this video, you will be able to summarize data by multiple groups using BY-Group processing in SAS.
-
SAS Programming Essentials: Summarizing Data by Groups
After watching this video, you will be able to summarize data by groups using BY-Group processing in SAS.
-
SAS Programming Essentials: Creating an Accumulating Variable Using SUM
After watching this video, you will be able to use the SUM statement to create an accumulating variable in SAS.
-
SAS Programming Essentials: Writing to Multiple SAS Data Sets
After watching this video, you will be able to write to more than one SAS data set.
-
SAS Programming Essentials: Outputting Multiple Observations
After watching this video, you will be able to control when SAS writes an observation to a data set using an OUTPUT statement.
-
SAS Programming Essentials: Creating Reports and Charts
After watching this video, you will be able to create and chart a summary report and a frequency table in SAS.
-
SAS Programming Essentials: Producing Scatter Plots with SAS/GRAPH SG Procedures
After watching this video, you will be able to create scatter plots using SAS/GRAPH statistical graphics procedures.
-
SAS Programming Essentials: Controlling Observation Input and Output
After watching this video, you will be able to control SAS observation input and output with OBS and FIRSTOBS.
-
SAS Programming Essentials: Controlling Variable Input and Output
After watching this video, you will be able to control SAS variable input and output with DROP and KEEP.
-
SAS Programming Essentials: Creating Histograms with SAS/GRAPH SG Procedures
After watching this video, you will be able to create histogram charts SAS/GRAPH statistical graphics procedures.
-
SAS Programming Essentials: Creating Bar Charts with SAS/GRAPH SG Procedures
After watching this video, you will be able to create bar charts using the SAS/GRAPH statistical graphics procedures.
-
SAS Programming Essentials: Creating Pie Charts with SAS/GRAPH SG Procedures
After watching this video, you will be able to create pie charts using the SAS/GRAPH statistical graphics procedures.
-
SAS Programming Essentials: Overview of SAS/GRAPH SG Procedures
After watching this video, you will be able to describe the capabilities of the SAS/GRAPH statistical graphics procedures.