https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Data-from-Oracle/m-p/5895#M531 The documentation may be of some help. See page 4 for examples:<BR /> <A href="http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_oracle_7367.pdf" target="_blank">http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_oracle_7367.pdf</A><BR /> <BR /> This other document may be of interest:<BR /> <A href="http://support.sas.com/techsup/technote/ts703.pdf" target="_blank">http://support.sas.com/techsup/technote/ts703.pdf</A><BR /> <BR /> For specific help with your configuration and database, you might consider contacting Tech Support.<BR /> <BR /> cynthia Sun, 16 Dec 2007 05:17:45 GMT Cynthia_sas 2007-12-16T05:17:45Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Data-from-Oracle/m-p/5894#M530 Hi,<BR /> <BR /> 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!!!<BR /> <BR /> Thanks in advance.<BR /> <BR /> Cathy Sun, 16 Dec 2007 03:29:33 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Data-from-Oracle/m-p/5894#M530 deleted_user 2007-12-16T03:29:33Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Data-from-Oracle/m-p/5895#M531 The documentation may be of some help. See page 4 for examples:<BR /> <A href="http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_oracle_7367.pdf" target="_blank">http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_oracle_7367.pdf</A><BR /> <BR /> This other document may be of interest:<BR /> <A href="http://support.sas.com/techsup/technote/ts703.pdf" target="_blank">http://support.sas.com/techsup/technote/ts703.pdf</A><BR /> <BR /> For specific help with your configuration and database, you might consider contacting Tech Support.<BR /> <BR /> cynthia Sun, 16 Dec 2007 05:17:45 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Data-from-Oracle/m-p/5895#M531 Cynthia_sas 2007-12-16T05:17:45Z