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.
posted by Linda J. Adams @ 12:46 PM
6 Comments:
I also suggest picking up a proc sql user guide which is an indispensible resource. Thanks for the information.
Proc SQL User Guide
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
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
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
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
such an ideal piece of blog.it's quite interesting to read content like this.
ADAM online Training
Post a Comment
<< Home