topic Re: get a creation script of a dataset to run it on another server in SAS Programming

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

Nasser_DRMCP — Fri, 23 Nov 2018 14:10:55 GMT

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

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

RW9 — Fri, 23 Nov 2018 14:16:42 GMT

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

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

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

Nasser_DRMCP — Fri, 23 Nov 2018 14:23:58 GMT

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

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

Nasser_DRMCP — Fri, 23 Nov 2018 14:28:34 GMT

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

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

RW9 — Fri, 23 Nov 2018 14:35:14 GMT

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