Date:         Fri, 10 Sep 2004 15:03:35 +0800
Reply-To:     "Rex.Lv" <rex.lv@126.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Rex.Lv" <rex.lv@126.COM>
Organization: Bentium Ltd. (CN99)
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