The SAS Output Delivery System and reporting techniques

Oracle table to SAS

Reply
N/A
Posts: 1

Oracle table to SAS

Hi,

I am new at SAS . I have a basic problem I want to analysis my oracle table on the SAS, So how can I send to my oracle table to SAS?

Valued Guide
Posts: 2,174

Oracle table to SAS

see the example at the foot of the documentation for SAS statement LIBNAME to access Oracle

Contributor
Posts: 54

Oracle table to SAS

To add another real world example:

If I go to my ODBC administrator in Windows and choose my odbc connection for my Oracle server and hit configure, it will show me the server name:

Server: OrServ

So at the top of my SAS program, I’ll add the below to use the Oracle connection almost like it’s a local SAS library.

%let orcuser=MyUserName;

%let orcpass=MyPassword;

libname OrServ oracle user="&orcuser." password="&orcpass." path='OrServ';

Then I can see my Oracle tables in the SAS explorer under the library named OrServ and can use it almost like any other library.

Proc sql;

Create table work.LocalTable as

      Select MyField1, MyField2

      From OrServ.OracleTableName

      Where ...

;

quit;

Ask a Question
Discussion stats
  • 2 replies
  • 159 views
  • 0 likes
  • 3 in conversation