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
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.
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