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 ----------------------------------------------------------------------------