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.
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;
Bruno
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.