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 2002, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Sat, 13 Apr 2002 07:52:05 +0200
Reply-To:   Andreas Grueninger <grueninger@IBGRUENINGER.DE>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Andreas Grueninger <grueninger@IBGRUENINGER.DE>
Organization:   T-Online
Subject:   Re: Handling the $ in an ODBC libref to an Excel file.
Content-Type:   text/plain; charset=ISO-8859-1

I don't know how to get rid of this ugly (it is the internal name) name. But here an example how to get a SAS table from an excel file.

* --- use here your method to get a libname for the excel file ; %getODBCLibref (DBMS=MSEXCEL,libref=test,DBQ=c:\temp\test.xls); OPTIONS VALIDVARNAME=any; DATA sheet1; SET test.'sheet1$'n; RUN; LIBNAME test CLEAR; OPTIONS VALIDVARNAME=V7;

"FMAINVILLE" <fmr@magma.ca.nospam> schrieb im Newsbeitrag news:zTIt8.25735$Hl2.877702@wagner.videotron.net... > Greetings to all, > > In defining an ODBC Libref to Excel, the dataset name get represented as > Sheet1$ > I have spent the day toying with the various quoting functions with out > success... > Converting to Ms Access solved the issue, but is there a way to handle the $ > ? > > For example, in the following code > > Proc sql; > select * from mylib.sheet1$ ; > quit; > > SAS will complain about the $. > Any way of fixing this ? > > Thanks in advance, > F. Mainville > Statistics Canada >


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