You have to open your excel data, put it in icon and write:

FILENAME IN1 DDE 'EXCEL|[PLNRTBL.XLS]PLNRTBL!R3C4:R159C10';

I use it with Win95 and office 95 and it works.

Louis.

Thomas T. Barney <tbarney@bcstec.ca.boeing.com> a icrit dans l'article <335CD765.2807@bcstec.ca.boeing.com>... > The following code works when in windows3.11 and excel 5.0 and PCSAS > 6.11, however it returns a message of file name not present under win95 > and Excel in Office95 and SAS6.11. Anyone know why or what I did wrong. > > Also of note is that we are reading 3 nonconsecutive columns. > > TIA. > > code follows: > > FILENAME IN1 DDE 'EXCEL|D:\DATA\TEXT\[PLNRTBL.XLS]PLNRTBL!R3C4:R159C10'; > > OPTIONS ERRORS=1; > DATA DEST; > INFILE IN1 DLM='09'X NOTAB DSD MISSOVER; > INPUT TEST1 $ TEST2 $ TEST3 $ TEST4 $ ; > *INPUT DEST1 LEAD $ MGR $ ; > /* IF LEAD='XXX' THEN DELETE; > IF DEST1<=. THEN DELETE; > DEST=PUT(DEST1,Z3.0); > ALL=DEST||LEAD||MGR; */ > > RUN; > > Thomas Barney > tbarney@bcstec.ca.boeing.com >