This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SAS Programming on Proc SQL Part 2
Section 1: Course Overview and Supplements
Course Overview (2:43)
course supplements: SAS codes and Data files in zip folders (0:35)
Section 2: Creating and Updating Tables and Views
Create Tables without Rows by using the CREATE TABLE Statement (4:35)
Create Tables from a Query Result using CREATE TABLE with AS Keyword (5:42)
Create Tables like an Existing Table with LIKE clause & Copy an Existing Table (5:40)
Insert Rows into Tables using Insert Statement with the SET Clause (7:44)
Insert Rows into Tables using Insert Statement with the VALUE Clause (7:03)
Insert Rows into Tables using Insert Statement with a Query (7:55)
Update All Rows with the Same Expression using Update Statement (5:39)
Update All Rows with Different Expressions using Update Statement (10:07)
Delete Rows with the DELETE statement (4:14)
Alter Columns with the ALTER TABLE statement: Add a Column (7:41)
Alter Columns with the ALTER TABLE statement: Modify or Delete a Column (3:23)
Use SQL Procedure Tables & Delete Tables (3:58)
Proc SQL Views: Create, Describe, and Delete PROC SQL Views (6:48)
Proc SQL Views: Use Proc SQL Views (4:14)
Proc SQL Views: Specify/Use In-Line Views (7:18)
Quiz
Coding Exercise
Coding Exercise: Solution
Section 3: Practical Examples Using PROC SQL
Comparing Old and New Tables (5:54)
Overlaying Missing Data Values (7:47)
Computing Percentages within Subtotals (9:23)
Counting Duplicate Rows in a Table (4:19)
Expanding Hierarchical Data in a Table (5:37)
Summarizing Data in Multiple Columns (5:04)
Creating a Summary Report (8:22)
Creating a Customized Sort Order (6:31)
Updating a Table with Values from Another Table (7:58)
Alter Columns with the ALTER TABLE statement: Add a Column
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock