Filtering Rows Using the WHERE Clause4min
Special WHERE Operators: Missing Values52s
Additional Special WHERE Operators1min
Sorting the Output with the ORDER BY Clause33s
Ordering Columns by Position17s
Enhancing Reports4min
Demo: Creating Simple Reports4min
Creating a New Column1min
Subsetting Calculated Values43s
Assigning Values Conditionally with the CASE Expression1min
Demo: Assigning Values Conditionally2min
Eliminating Duplicate Rows with the DISTINCT Keyword54s
Summarizing Data1min
Demo: Using Summary Functions to Analyze a Table3min
Summarizing Data Using the COUNT Function20s
Grouping Data2min
Demo: Analyzing Groups of Data4min
Summarizing Date and Time Data1min
Counting Rows Using a Boolean Expression37s
Demo: Summarizing Data Using a Boolean Expression2min
Creating Tables1min
Creating Tables from a Query1min
Creating Table Structures1min
Inserting Rows into Tables2min
Dropping Tables in PROC SQL10s
Scenario31s
DICTIONARY Tables1min
Demo: Using DICTIONARY Tables5min