LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2012, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 19 Apr 2012 12:36:13 -0400
Reply-To:   Christopher Battiston <darth.pathos@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Christopher Battiston <darth.pathos@GMAIL.COM>
Subject:   SAS not able to "see" some tables in Oracle
Content-Type:   text/plain; charset=ISO-8859-1

Good afternoon everyone!

A quick question - I have some tables in Oracle that when I try and connect to using PROC SQL, I'm getting "myconn.[table name].data does not exist". I'm thinking the table names are reserved words (they are called TEST and PROCEDURE). In SQL Server, you could put square brackets around tables that had names "not allowed" by the database, but that didn't work in SAS.

I know I have full access to these tables as I can get to them through other means (Oracle's SQL Developer, Eclipse, etc.).

Any thoughts would be appreciated... Chris


Back to: Top of message | Previous page | Main SAS-L page