Date:         Thu, 13 May 1999 09:42:25 -0500
Reply-To:     Michael S Hines <mshines@PURDUE.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Michael S Hines <mshines@PURDUE.EDU>
Subject:      Re: DDE
In-Reply-To:  <0004F213.C21292@westat.com>
Content-Type: text/plain; charset="us-ascii"

The only changes I would make to Ed's suggestion would be to use options on
the INFILE statement as documented in the SAS Companion for Microsoft
Windws Environment, The SAS Companion for the Microsoft Windows NT
Environment, A Handbook for SAS Users, and The Little SAS Book: A Primer -
namely
 
INFILE  yourfilename dsd dlm='09'x missover;
 
dsd provides protection for empty Excel cells (that is back to back field
separators)
dlm provides for tab separation of columns the default method of DDE
processing
missover provides that if you have more fields than columns that the extra
fields will be set to missing values (blank for character, . for numeric).
without missover, the system reads the next logical record to try to assign
values to your data fields - not what you want I expect.
 
There are samples at the following site if you are interested.
http://www.adpc.purdue.edu/SAS/pcsas.htm
 
 
===================================================================
Internet: mshines@purdue.edu  | Michael S. Hines  CDP,CISA,CIA,CFE
Voice: (765) 494-5338         | Coordinator of Systems and Programming
FAX:   (765) 496-1466         | Purdue University
                              | 1280 Engineering Administration
                              | West Lafayette, IN 47907-1280