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 (September 2010, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 23 Sep 2010 14:12:48 -0700
Reply-To:     "Nordlund, Dan (DSHS/RDA)" <NordlDJ@DSHS.WA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Nordlund, Dan (DSHS/RDA)" <NordlDJ@DSHS.WA.GOV>
Subject:      Re: Problems reading Excel files
In-Reply-To:  <123206.82759.qm@web32401.mail.mud.yahoo.com>
Content-Type: text/plain; charset=utf-8

> -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of > Dale McLerran > Sent: Thursday, September 23, 2010 12:44 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Problems reading Excel files > > I just got a new computer (Yay!) It is a 64-bit machine with > Windows 7 Enterprise OS installed. The OS is 64-bit. The SAS > install is also 64-bit. > > Previously, when I wanted to read/write an Excel spreadsheet > from SAS, I would submit a libname statement which specified > the Excel engine as shown below: > > libname BL_WH excel > "Q:\SBERESFO\PACE\Data\Baseline\Intensive Assessment H_W_C > 013008.xls"; > > > On my new system, when I submit the above code, I get an error > message as shown below: > > ERROR: The EXCEL engine cannot be found. > ERROR: Error in the LIBNAME statement. > > > SAS was originally installed by a system administrator without > my input, and I though that perhaps he did not include the > SAS ACCESS component for PC files. I reported the problem to > him, and together we reinstalled SAS (over the top of the > previous install). The SAS Foundation component showed SAS > ACCESS for PC files as being available and it was checked off > for installation. > > Even after reinstalling SAS, I still get the same error message. > A complete log of my SAS session, including results from a > PROC SETINIT, is shown below (blanking out the Site number in > case there might be issues publishing such information). I would > appreciate any ideas about what the problem is with specifying the > Excel engine. > > > > NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA. > NOTE: SAS (r) Proprietary Software 9.2 (TS2M3) > Licensed to FRED HUTCHINSON CANCER RESEARCH CENTER, Site > xxxxxxxx. > NOTE: This session is executing on the X64_VSPRO platform. > > > > NOTE: SAS initialization used: > real time 1.64 seconds > cpu time 0.90 seconds > > NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened > instead. > NOTE: All profile changes will be lost at the end of the session. > NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened > instead. > NOTE: All profile changes will be lost at the end of the session. > > 1 libname BL_WH excel "Q:\SBERESFO\PACE\Data\Baseline\Intensive > Assessment H_W_C 013008.xls"; > ERROR: The EXCEL engine cannot be found. > ERROR: Error in the LIBNAME statement. > 2 > 3 > 4 proc setinit; > 5 run; > > NOTE: PROCEDURE SETINIT used (Total process time): > real time 0.02 seconds > cpu time 0.01 seconds > > Original site validation data > Site name: 'FRED HUTCHINSON CANCER RESEARCH CENTER'. > Site number: 70093618. > Expiration: 30AUG2011. > Grace Period: 45 days (ending 14OCT2011). > Warning Period: 45 days (ending 28NOV2011). > System birthday: 24AUG2010. > Operating System: WX64_WKS. > Product expiration dates: > ---Base Product 30AUG2011 > ---SAS/STAT 30AUG2011 > ---SAS/GRAPH 30AUG2011 > ---SAS/ETS 30AUG2011 > ---SAS/FSP 30AUG2011 > ---SAS/OR 30AUG2011 > ---SAS/AF 30AUG2011 > ---SAS/IML 30AUG2011 > ---SAS/QC 30AUG2011 > ---SAS/SHARE 30AUG2011 > ---SAS/LAB 30AUG2011 > ---SAS/ASSIST 30AUG2011 > ---SAS/CONNECT 30AUG2011 > ---SAS/INSIGHT 30AUG2011 > ---SAS/EIS 30AUG2011 > ---SAS/GIS 30AUG2011 > ---SAS/SHARE*NET 30AUG2011 > ---MDDB Server common products 30AUG2011 > ---SAS/Secure Windows 30AUG2011 > ---SAS/Genetics 30AUG2011 > ---OR OPT 30AUG2011 > ---OR PRS 30AUG2011 > ---OR IVS 30AUG2011 > ---OR LSO 30AUG2011 > ---SAS/ACCESS Interface to DB2 30AUG2011 > ---SAS/ACCESS Interface to ORACLE 30AUG2011 > ---SAS/ACCESS Interface to PC Files 30AUG2011 > ---SAS/ACCESS Interface to ODBC 30AUG2011 > ---SAS/ACCESS Interface to MYSQL 30AUG2011 > ---SAS Stat Studio 30AUG2011 > ---SAS Workspace Server for Local Access 30AUG2011 > > > Thanks, > > Dale >

Dale,

Try something like the following

libname BL_WH excelcs path="Q:\SBERESFO\PACE\Data\Baseline\Intensive Assessment H_W_C 013008.xls" server='your computer name' port=8621;

This syntax works on my system (similar to what you described). I just used the computer name that displays when I display the properties of my computer.

Hope this is helpful,

Dan

Daniel J. Nordlund Washington State Department of Social and Health Services Planning, Performance, and Accountability Research and Data Analysis Division Olympia, WA 98504-5204


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