https://communities.sas.com/t5/SAS-Procedures/converting-sas-access-view-to-sas-data-set/m-p/43398#M11331 Hi Duke,<BR /> Thank you for fyour responding for which i was posted the message. now i will check and do the best.<BR /> <BR /> Thanks<BR /> ANJI... Fri, 12 Jun 2009 09:28:52 GMT deleted_user 2009-06-12T09:28:52Z https://communities.sas.com/t5/SAS-Procedures/converting-sas-access-view-to-sas-data-set/m-p/43396#M11329 Hi,<BR /> I am extracting data from oracle clinical to sas using sas/Access its giving sas/Access view. Now i am trying to convert sas/Access view data set to sas data set, but it's giving following error is:<BR /> <BR /> ERROR: ORACLE connection error: ORA-12560: TNS:protocol adapter error.<BR /> ERROR: SQL View VIEW.ADEV could not be processed because at least one<BR /> of the data sets, or views, referenced directly (or indirectly)<BR /> by it could not be located, or opened successfully. Thu, 11 Jun 2009 06:35:11 GMT https://communities.sas.com/t5/SAS-Procedures/converting-sas-access-view-to-sas-data-set/m-p/43396#M11329 deleted_user 2009-06-11T06:35:11Z https://communities.sas.com/t5/SAS-Procedures/converting-sas-access-view-to-sas-data-set/m-p/43397#M11330 See this thread.<BR /> <BR /> <A href="http://support.sas.com/forums/thread.jspa?threadID=6140&amp;tstart=0" target="_blank">http://support.sas.com/forums/thread.jspa?threadID=6140&amp;tstart=0</A> Thu, 11 Jun 2009 11:31:16 GMT https://communities.sas.com/t5/SAS-Procedures/converting-sas-access-view-to-sas-data-set/m-p/43397#M11330 Doc_Duke 2009-06-11T11:31:16Z https://communities.sas.com/t5/SAS-Procedures/converting-sas-access-view-to-sas-data-set/m-p/43398#M11331 Hi Duke,<BR /> Thank you for fyour responding for which i was posted the message. now i will check and do the best.<BR /> <BR /> Thanks<BR /> ANJI... Fri, 12 Jun 2009 09:28:52 GMT https://communities.sas.com/t5/SAS-Procedures/converting-sas-access-view-to-sas-data-set/m-p/43398#M11331 deleted_user 2009-06-12T09:28:52Z