08-24-2016 12:17 PM
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.
08-24-2016 12:35 PM
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;
See also this sample code here:
data newCars; seqNr = _n_; set sashelp.cars; run; proc sql; create index seqNr on newcars; describe table newCars; create table newCars2 like newCars; describe table newCars; quit;