Describe Your Table in SAS to Write the SQL Code
Ever had the need to write SQL create statements for existing tables but felt too lazy to write it by hand? Ever wanted to reverse engineer tables into SQL code? Have no fear, PROC SQL is here. Use the DESCRIBE statement to get the full blown SQL code to create the table. This is particularly good for generating empty table structures to insert data with ETL code. In the data warehousing world, having SQL code to create empty tables is referred to as the Data Definition Language (DDL).
Example: Describe Statement Using PROC SQL
Running the following describe statement produces the SQL create statement to define the table and columns.
proc sql; describe table SASHELP.CLASS; quit;
The SAS log provides the create statement:
SAS Support provides additional information on the DESCRIBE statement.
Never miss a BI Notes post!
Click here for free subscription. Once you subscribe you'll be asked to confirm your subscription through your email account. You email address is kept private and you can unsubscribe anytime.
Latest posts by Steve Overton (see all)
- Need to Migrate Users, Groups, and Roles between SAS Environments? - 2013-11-05
- BulkLoading with PostgreSQL available in SAS 9.4 - 2013-10-22
- Everything Still Starts and Ends with Data in SAS Visual Analytics - 2013-07-30
- Coding: Quick Tip for Exploiting and Identifying SAS Formats - 2013-07-15
- Describe Your Table in SAS to Write the SQL Code - 2013-05-22
Tags: Data Management