I have some long text fields in an excel spreadsheet that I would like to
load into SAS. The import procedure is truncating at 255 characters. Is
there a way to override this? Unfortunately, import with dbms=excel does
not support the datarow option. TIA

PROC IMPORT OUT= WORK.test
            DATAFILE= "k:\book1.xls"
            DBMS=EXCEL2000 REPLACE;
     GETNAMES=YES;
RUN;

I have exported to MS Access and imported from there to work around this on
the fly.

hth

Paul Choate
DDS Data Extraction
(916) 654-2160

-----Original Message-----
From: saslist@COMCAST.NET [mailto:saslist@COMCAST.NET]
Sent: Wednesday, March 03, 2004 10:24 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: proc import truncating

I have some long text fields in an excel spreadsheet that I would like to
load into SAS. The import procedure is truncating at 255 characters. Is
there a way to override this? Unfortunately, import with dbms=excel does
not support the datarow option. TIA

PROC IMPORT OUT= WORK.test
            DATAFILE= "k:\book1.xls"
            DBMS=EXCEL2000 REPLACE;
     GETNAMES=YES;
RUN;