Filtering Rows Using the WHERE Clause4 分
Special WHERE Operators: Missing Values52
Additional Special WHERE Operators1 分
Sorting the Output with the ORDER BY Clause33
Ordering Columns by Position17
Enhancing Reports4 分
Demo: Creating Simple Reports4 分
Creating a New Column1 分
Subsetting Calculated Values43
Assigning Values Conditionally with the CASE Expression1 分
Demo: Assigning Values Conditionally2 分
Eliminating Duplicate Rows with the DISTINCT Keyword54
Summarizing Data1 分
Demo: Using Summary Functions to Analyze a Table3 分
Summarizing Data Using the COUNT Function20
Grouping Data2 分
Demo: Analyzing Groups of Data4 分
Summarizing Date and Time Data1 分
Counting Rows Using a Boolean Expression37
Demo: Summarizing Data Using a Boolean Expression2 分
Creating Tables1 分
Creating Tables from a Query1 分
Creating Table Structures1 分
Inserting Rows into Tables2 分
Dropping Tables in PROC SQL10
Scenario31
DICTIONARY Tables1 分
Demo: Using DICTIONARY Tables5 分