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
Yes, describe will give you the SQL to re-create a table/dataset.
Sorry, you request is terribly unclear? If you want an empty data just create one:
proc sql; create table want (abc char(200)); quit;
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
Yes, describe will give you the SQL to re-create a table/dataset.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.