topic Re: Can SAS dataset be exported as Oracle Table without dbms connection/ odbc connection in SAS Programming

Can SAS dataset be exported as Oracle Table without dbms connection/ odbc connection

rajesh_k_jha_accenture_com — Tue, 02 Aug 2016 19:32:23 GMT

HI Team,

Is there a way to export a sas dataset as Oracle/SQL Table without having a Connect to oracle(Odbc connection)??

The basic need here is to make data ready to upload in oracle, which is on a different machine as well as on different network and didn't have SAS Installation.

Any help will be appreciated.

Thanks in advance,

Regards,

Rajesh

Re: Can SAS dataset be exported as Oracle Table without dbms connection/ odbc connection

SASKiwi — Tue, 02 Aug 2016 19:42:28 GMT

Databases usually have the ability to import delimited files (CSV etc). You can export your SAS data to a CSV and then import that into Oracle.

Re: Can SAS dataset be exported as Oracle Table without dbms connection/ odbc connection

LinusH — Tue, 02 Aug 2016 23:31:37 GMT

Technically I don't think that Oracle tables can't live outside a database, so you need a connection.
The closest SAS can offer are the creation of bulk load files. But I think that SAS still needs a connection to produce these since it's a part of an integrated load step.
So I guess that the suggestion by @SASKiwi is the way to go, given that I understood the problem description correctly.