Wednesday, October 18, 2006

PROC SQL and the DESCRIBE TABLE Statement

You can use the DESCRIBE TABLE statement in PROC SQL to display information about a SAS dataset. The information is displayed in the log. Whether the data set described was created with a DATA step or PROC SQL, the log will display the CREATE TABLE statement required to create it.

If applicable, SAS data set options are included with the table definition. If indexes are defined on columns in the table, then CREATE INDEX statements for those indexes are also written to the SAS log.

Unlike PROC CONTENTS, the CREATE TABLE statement also displays the name of the SAS program used to create the data set.

Here is an example:

libname abc '/home/sas/data';
proc sql;
describe table abc.customers;
quit;

The resulting log shows the CREATE TABLE statement that would create abc.customers with PROC SQL.

6 Comments:

At 12:30 PM, Anonymous Wayne said...

I also suggest picking up a proc sql user guide which is an indispensible resource. Thanks for the information.

Proc SQL User Guide

 
At 11:09 PM, Blogger Andria BZ said...

This technical post helps me to improve my skills set, thanks for this wonder article I expect your upcoming blog, so keep sharing..
Regards,
sas training in Chennai

 
At 2:36 AM, Blogger Roshini RS said...


The information you have given here is truly helpful to me. CCNA- It’s a certification program based on routing & switching for starting level network engineers that helps improve your investment in knowledge of networking & increase the value of employer’s network...
Regards,
ccna course in Chennai|ccna training in Chennai|ccna training institute in Chennai

 
At 4:47 AM, Blogger Andria BZ said...

Thanks for sharing this valuable post to my knowledge great pleasure to be here SAS has great scope in IT industry. It’s an application suite that can change, manage & retrieve data from the variety of origin & perform statistical analytic on it…
Regards,
sas training in Chennai|sas course in Chennai|sas training institute in Chennai

 
At 3:39 AM, Blogger Raju Kumar said...

nice post and site, good work! This article is well written and quite informative. More articles should be written and you have just found a follower.and more visit
sas online training

 
At 1:44 AM, Blogger deeksha said...

this blog is really good and useful for many people who are based on software based studies thanks for sharing those information.


ccna training in chennai

 

Post a Comment

<< Home