Date:         Sat, 12 Feb 2005 04:43:09 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: Excel engine in MVS
Comments: To: eiwenchang@hotmail.com
In-Reply-To:  <1108165220.910493.266970@z14g2000cwz.googlegroups.com>
Content-Type: text/plain; format=flowed

Yi,

Your out of luck MVS doesn't support the excel engine.  I am not even sure
how you would get a excel file properly loaded on a MVS system without
transforming it first into something else.

My best solution off teh top of my balding head would be to first take your
excel data and get it into a comma delimited file and then upload that
either through PC SAS or FTP, butthen if you have PC SAS just do the
conversion with that and then proc upload or ftp it up to the Big Iron.



Toby Dunn




From: Yi <eiwenchang@HOTMAIL.COM>
Reply-To: Yi <eiwenchang@HOTMAIL.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Excel engine in MVS
Date: Fri, 11 Feb 2005 15:40:20 -0800


Could someone help me. I use the following to try and read data to the
mainframe using MVS from network using SAS913.  Could you tell me what
I am doing wrong?  Why can I not find the EXCEL engine?  Thanks for
help.

libname exbk excel
   'PROJECTS\WV\WRM\blind\Blind papers- scored and flagged.xls'
    ver=2002;

  data test;
   set exbk.sheet1;
   run;

ERROR: The EXCEL engine cannot be found.
ERROR: Error in the LIBNAME statement.
i,