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 (October 2000, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 30 Oct 2000 16:30:41 -0800
Reply-To:   "William W. Viergever" <wwvierg@IBM.NET>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "William W. Viergever" <wwvierg@IBM.NET>
Subject:   Re: Read part of Excel spreadsheet
Comments:   To: wei cheng <cheng_wei@HOTMAIL.COM>
In-Reply-To:   <LAW2-F167adGzbxnB7Z0000280c@hotmail.com>
Content-Type:   text/plain; charset="us-ascii"; format=flowed

Can't speak for the other methods, but ....

with DDE, *if* you go with the current Excel columns ordering; then you'd have to *read* all columns up to an including the one(s) you wanted (so with 100+ there might be a bunch of wasted typing).

But, *if* you put (i.e., cut & paste) all the desired columns as the first N columns in the spreadsheet then DDE is pretty darn easy (just an input statement).

FWIW, there is a third way (which I do not use or like): use separate FILENAME statements for each column, then input the desired 10 and do a match merge to bring 'em all together.

HTH

At 11:51 PM 10/30/2000 +0000, wei cheng wrote: >SAS-Ls, > >We know that we have lots of method to read the Excel spreadsheet to SAS >data set, ODBC, DDE, PROC DBLOAD, PROC IMPORT,etc. But if the spreadsheet >has 100 columns and I only need to read 10 columns of them into a SAS data >set, which method is the best? > >TIA, > >Wei >_________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > >Share information about yourself, create your own public profile at >http://profiles.msn.com.

---------------------------------------------------------------------------- William W. Viergever Voice : (916) 483-8398 Viergever & Associates Fax : (916) 486-1488 A SAS Institute Quality Partner (USA) E-mail : wwvierg@ibm.net Sacramento, CA 95825 ----------------------------------------------------------------------------


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