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!!!
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.
From: Rex.Lv [mailto:rex.lv@126.COM]
Sent: Friday, September 10, 2004 3:04 PM
Subject: About Import Procedure, ASK FOR HELP!!!
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
RANGE="Sheet1$"; /*The sheet I want to import*/