Date: Mon, 28 May 2001 16:51:01 -0400
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Laura B Grady <lbgrady@UNITY.NCSU.EDU>
Organization: NC State University
Subject: Re: new Excel => import problems
Content-Type: text/plain; charset=us-ascii
v8.1 Import MSExcel 97/2000 Text Columns Imported with Length of 255
Using SAS 8.1/ACCESS Software for PC File Formats to read in an Excel
97/2000 text field, with PROC IMPORT or the Import Wizard, text columns
are imported with a length of 255.
This behavior is fixed in the following file:
>From the SAS Home Page -> Service & Support -> Technical Support ->FTP
Site -> SAS System on Personal Computers -> pcff_p81.zip
Product: SAS/ACCESS (General)
Component: ACCESS procedure or window
Status: Usage Issue
Date: Sun, 29 Oct 2000
"Ephraim I. Schechter" wrote:
> Our network techs just installed an Excel upgrade, to Excel97 SR-2. Proc
> Import now brings Excel files into SAS with all character fields set to
> $255 instead of to the length of the Excel field. This happens whether I
> specify dbms=excel97, dbms=excel2000, or just leave dbms= out of the proc
> import statement. I'm using SAS 8.01 (TS level 01M0) under WinNT.
> Microsoft's Data Access Components got overwritten with an older version by
> the Excel upgrade, but reinstalling MDAC v2.5 doesn't help.
> Any ideas on how to make the import read lengths properly? I've got a
> suite of programs with a lot of import steps, and am trying to avoid
> adding code that controls variable length to each one.
> Thanks --
> Ephraim Schechter
> Associate Director, University Planning & Analysis
> North Carolina State University