Date:         Mon, 18 Dec 2006 20:45:25 +0100
Reply-To:     Stéphane COLAS <scolas@DATAMETRIC.FR>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Stéphane COLAS <scolas@DATAMETRIC.FR>
Subject:      Re: SAS Explorer
In-Reply-To:  <4uo857F18hc7hU1@mid.individual.net>
Content-Type: text/plain; charset=ISO-8859-1

Also, I have a DWH with several @ in the names. I use a PRESERVE_COL_NAMES=yes
AND PRESERVE_tab_NAMES as options of the libname.

HTH.

Stéphane.


Selon "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET>:

> Wing9897@hotmail.com wrote:
> > Hello,
> >
> > I am trying to view in SAS Explorer some SQL tables via an ODBC
> > connection (libname test odbc dsn=test schema=dbo;).  Unfortunately,
> > when I try to open those SQL tables that have a "#" included in the
> > table name I get an error stating that the table does not have a valid
> > SAS name.  Does anyone have any suggestions on how to get around this
> > without renaming the actual SQL table itself?
> >
> > Any help would be appreciated.  Thanks.
>
> OPTIONS VALIDVARNAME=ANY;
>
> might help.
>
> --
> Richard A. DeVenezia
> http://www.devenezia.com/
>