Accessing ORACLE data through SAS.ppt.pptVIP

Accessing ORACLE data through SAS Susanne Young Bank One Overview You need to use SAS to access data stored in Oracle tables or views Options LIBNAME statement pass-thru SQL query LIBNAME statement LIBNAME MYORALIB ORACLE USER=MYUID PW=MYPASSWORD PATH=@OraInfo SCHEMA=MYSCHEMA; LIBNAME statement 14 LIBNAME MYORALIB ORACLE USER=MYUID PW=XXXXXXX PATH=@OraInfo SCHEMA=MYUID NOTE: Libref MYORALIB was successfully assigned as follows: Engine: ORACLE Physical Name: @OraInfo LIBNAME statement LIBNAME statement LIBNAME statement Helpful Info Automatic macro variables sysdb