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 (December 2006, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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/ >


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