LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (May 1999, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page