Data from Oracle

[deleted_user]

Hi,

Can someone pls explain or point me to the code for reading data from oracle using a libname statement involving proc sql? I understand that one can also use data step along with libname for doing the job. Is there any difference between these two approaches? The myriad of data importing techs in SAS is really a matter of confusion for a newbie like me!!!

Thanks in advance.

Cathy

[Cynthia_sas]

The documentation may be of some help. See page 4 for examples:
http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_oracle_7367.pdf

This other document may be of interest:
http://support.sas.com/techsup/technote/ts703.pdf

For specific help with your configuration and database, you might consider contacting Tech Support.

cynthia