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.
Creating and deleting tables in SQL
From the course: SAS® 9.4 Cert Prep: Part 07 Using SQL in SAS
Creating and deleting tables in SQL
- [Instructor] A report is great, but often you need to create tables instead of reports. That's not a problem. SQL makes this task easy, too. To produce a table from the query you can add a create table statement prior to select. For those writing SQL code for SAS to process in other database environments, you might need to drop or delete a table before updating it. If you have appropriate permission to make such changes within the database, you can use the drop table statement.
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.