topic Re: Best Way to build SQL statement from a describe table in SAS Programming

Best Way to build SQL statement from a describe table

jbanas — Wed, 24 Aug 2016 16:17:35 GMT

In teradata, you can see the table definition by running a show table xxx to get the contents on how it was created. In SAS you can also run this same code that writes out the contents to a table or perform a describe xxx which produces the code in a log. what i was looking to do is utilize SAS to read this code to recreate the table to perform a comparison on another table. The columns could always change so i want to make it as dynamic as possible. Waht would be the most efficient way to build a new table off of the describe statement.

Re: Best Way to build SQL statement from a describe table

BrunoMueller — Wed, 24 Aug 2016 16:35:15 GMT

If you just want to create a new table that has the same structure as the old table, you can use

create table newTable like oldTable;

Re: Best Way to build SQL statement from a describe table

jbanas — Wed, 24 Aug 2016 17:00:54 GMT

Thanks for the reply Bruno, ultimately I would take the column attributes that would build the table on Teradata

Re: Best Way to build SQL statement from a describe table

LinusH — Wed, 24 Aug 2016 19:45:06 GMT

Perhaps you should look for Teradata tools instead...