From the course: SAS® 9.4 Cert Prep: Part 07 Using SQL in SAS
Unlock this course with a free trial
Join today to access over 22,600 courses taught by industry experts.
Using table aliases
From the course: SAS® 9.4 Cert Prep: Part 07 Using SQL in SAS
Using table aliases
- [Instructor] Typing the full table names to qualify columns can be tedious. SQL enables you to assign an alias or nickname to a table in the FROM clause by adding the keyword AS and the alias of your choice. Then, you can use the alias in place of the full table name to qualify columns in the other clauses of a query. In this example, the alias for the two tables are the letters U and T.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.