get a creation script of a dataset to run it on another server

[Nasser_DRMCP]

hello,

i would like to obtain a sas creation script of an existing dataset.

the purpose is to launch this script on another server to get a copy of the table.

I only need the structure without datas

thanks a lot in advance

regards

Nasser

[RW9]

Sorry, you request is terribly unclear?  If you want an empty data just create one:

proc sql;
  create table want (abc char(200));
quit;

[Nasser_DRMCP]

Hi,
thanks for your quick respons.
sorry if my request is not clear enough.
I have got many existing  tables with datas on a production server.
I would like to get copies of theses tables on another qualifcation server.
by telling "copy" I mean only structure, no datas needs.
thus, is it possible to obtain the screation script of a table ? by getting it, I could launch the script on the qalification server to create the table.
thanks

[Nasser_DRMCP]

I found a solution
proc sql;
describe table histo.BASE_CONTRAT ;
quit;

[RW9 · Accepted solution]

Yes, describe will give you the SQL to re-create a table/dataset.