Date: Mon, 11 Aug 2008 10:37:45 -0400
Reply-To: "Chambers, Charles (CDC/CCEHIP/NCEH) (CTR)" <ayo6@CDC.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Chambers, Charles (CDC/CCEHIP/NCEH) (CTR)" <ayo6@CDC.GOV>
Subject: Re: IMPORT proc poblem - Excel 2002
In-Reply-To: <2c8557a00808110641y4e008a3byfde0397b534328a@mail.gmail.com>
Content-Type: text/plain; charset=us-ascii
I think you have to have SAS Access. I saw this note in the SAS Export
Help, but imagine it applies to Import also:
Restriction:
The availability of an output data source depends on
* the operating environment, and in some cases the platform, as
specified in the previous table.
* whether your site has a license to the SAS/ACCESS software for
PC file formats. If you do not have a license, only delimited files are
available.
Featured in:
Exporting a Delimited External File
<ms-its:C:\Program%20Files\SAS\SAS%209.1\core\help\proc.chm::/proc.hlp/a
000316290.htm> and Exporting a Microsoft Access Table
<ms-its:C:\Program%20Files\SAS\SAS%209.1\core\help\proc.chm::/proc.hlp/a
000316856.htm>
Charles Chambers
Database Manager
Emergint Technologies Inc
CDC/NCEH/DLS/OAT
Contemporary Pesticides Laboratory
4770 Buford Hwy, M/S F-17
Atlanta, GA 30341
Work 770-488-4170
Cell 404-271-6421
cchambers@cdc.gov
http://www.cdc.gov/nceh/dls/default.htm
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Erwan LE DU
Sent: Monday, August 11, 2008 9:42 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: IMPORT proc poblem - Excel 2002
Hi all,
I am trying to import an Excel 2002 file using proc import. It won't
work
arghhhh.
*
PROC* *IMPORT* DATAFILE= 'H:\SAS\FG490M06_TITLES.xls'
OUT= SAS.TITLES
DBMS=EXCEL REPLACE;
GETNAMES=YES;
SHEET='TITLES';
*
RUN*;
When submitting, I get the following error message :
*DBMS type EXCEL not valid for import*
Any help would be appreciated.
Thanks,
Regards,
Ker
