Date:         Fri, 10 Sep 2004 17:49:07 +0800
Reply-To:     KUMAR Arun <KUMARA@ESSILOR.COM.SG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         KUMAR Arun <KUMARA@ESSILOR.COM.SG>
Subject:      Re: About Import Procedure, ASK FOR HELP!!!
Comments: To: "Rex.Lv" <rex.lv@126.COM>
Content-Type: text/plain

Hi Rex,
I remember facing the same type of problems. Perhaps SAS decide the length
of columns based on few observations(I don't remember exactly perhaps 20).
So one way out is go to the sas log, copy the relevant proc import codes and
change the length according to your need for the columns.

Regards,
Arun Kumar

-----Original Message-----
From: Rex.Lv [mailto:rex.lv@126.COM]
Sent: Friday, September 10, 2004 3:04 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: About Import Procedure, ASK FOR HELP!!!


Hi,


I want to import some data from excel files, but I'm lost. The columns that
have over 25 characters are automatically truncated to 25 character. Anybody
could give me a hand? Thx. a lot!


The code that I used to import data is as followed:

PROC IMPORT OUT= WORK.t
            DATAFILE= "C:\datafile.xls"  /*The excel file includes the
data*/
            DBMS=EXCEL2000 REPLACE;
     RANGE="Sheet1$";                    /*The sheet I want to import*/
     GETNAMES=YES;
RUN;


Best Regards,
Rex