Date:         Fri, 15 Mar 2002 08:46:50 -0800
Reply-To:     "William W. Viergever" <wwvierg@ATTGLOBAL.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "William W. Viergever" <wwvierg@ATTGLOBAL.NET>
Subject:      Re: Now it works: How to pull mixed-type Excel columns as
              character
Comments: To: hp <lowprice101@YAHOO.COM>
In-Reply-To:  <2e235b0.0203150807.38b8db2a@posting.google.com>
Content-Type: text/plain; charset="us-ascii"; format=flowed

At 08:07 AM 3/15/2002 -0800, hp wrote:
>Thank you all for your help. This is the code finally working:
>
>FILENAME agein
>         DDE "EXCEL|[age0.xls]sheet1!r2c1:r50c7";
>
>   DATA age0;
>     INFILE agein missover DLM='09'X NOTAB DSD ;
>     LENGTH
>         AgeVISN $8 AgeStation $6
>     CaseNo $12 CurrentStatus $4
>         ;
>         informat CreateDate mmddyy10. CloseDate mmddyy10.
>     ;
>     INPUT
>         AgeVISN $ AgeStation $
>     CaseNo $ CurrentStatus $
>     CreateDate CloseDate
>     AgeDays;
>   RUN;


I'm surprised it is working, however, I don't know how you have the columns
in Excel formatted.

Typically, you'd be well advised to employ the colon modifier for reading
fields from Excel to avoid problems of reading something shorter than what
you formatted.

Peter Crawford has posted many times on this subject; you may want to check
the archives for some of these.

HTH
------------------------------------------------------------
William W. Viergever          Voice  : (916) 483-8398
Viergever & Associates        Fax    : (916) 486-1488
Sacramento, CA 95825          E-mail : wwvierg@attglobal.net
------------------------------------------------------------