topic Re: Enterprise Guide - duplicate oracle database into sas tables in a library in New SAS User

Enterprise Guide - duplicate oracle database into sas tables in a library

SIgnificatif — Mon, 08 Apr 2019 06:56:00 GMT

Hi Dear All.

I would like to ask you if there is a command ( a loop ?) to duplicate (with contents) an oracle database and put all created tables with same name in a library.
the other question is how to save into a server and not local machine ( EG is installed in a local machine and database and the output should be on a server ) ?

Thank you for your comments.

Re: Enterprise Guide - duplicate oracle database into sas tables in a library

andreas_lds — Mon, 08 Apr 2019 07:14:15 GMT

I would like to ask you if there is a command ( a loop ?) to duplicate (with contents) an oracle database and put all created tables with same name in a library.

Do you want the clone in oracle or datasets in the file-system? If you want to store the clone in oracle, use tools provided by oracle. If you want datasets, use proc copy.

the other question is how to save into a server and not local machine ( EG is installed in a local machine and database and the output should be on a server ) ?

Is SAS running on your local machine or on a server?

Re: Enterprise Guide - duplicate oracle database into sas tables in a library

SIgnificatif — Mon, 08 Apr 2019 07:21:55 GMT

Thank you for the qyuick response.

1) i would like to clone to datasets , I was looking for the exact command and if I need a loop ?

2) the Enterprise guide is running in local machine, I want t have all files saved in server ( I'm looking how to configure the -work file)

and save the data into distant server ( the same where the oracle database are or some shared folders)..
I don't want the new sas tables to be saved in local machine)

Thank you !

Re: Enterprise Guide - duplicate oracle database into sas tables in a library

Kurt_Bremser — Mon, 08 Apr 2019 08:01:34 GMT

Enterprise Guide is just a frontend for your SAS session, which might be running on a "server" called "Local" (SAS installed on your desktop), or on a remote server (then it's usually called SASApp, the default name). The SAS session has access to all resources available in the context where it is run.

So you need to make sure that you can access your intended target from your SAS session; verify that with your SAS and/or system administrators.

Within SAS, proc copy will be the tool to use.

Re: Enterprise Guide - duplicate oracle database into sas tables in a library

andreas_lds — Mon, 08 Apr 2019 08:13:26 GMT

1) i would like to clone to datasets , I was looking for the exact command and if I need a loop ?

Please look up the documentation of proc copy. Reading the documentation is almost always faster than waiting for the community.