Date:         Sat, 12 Feb 2005 11:07:37 +0100
Reply-To:     Datametric <datametric@CLUB-INTERNET.FR>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Datametric <datametric@CLUB-INTERNET.FR>
Subject:      RE : Excel engine in MVS
In-Reply-To:  <BAY101-F3680470D98B5DAEA04F7BDE680@phx.gbl>
Content-Type: text/plain; charset="iso-8859-1"

It seems to me that we have a proc template to do that ?


  proc template;
    define tagset Tagsets.MyPhtml;
      parent = Tagsets.Phtml;
      define event anchor;
         block anchor;
      end;
      define event colgroup;
         block colgroup;
      end;
      define event colspec_entry;
         block colspec_entry;
      end;
      define event doc_body;
         block doc_body;
      end;
      define event proc;
         block proc;
      end;
      define event output;
         block output;
      end;
    end;
  run;

  filename htmlout '/myowndir/myexcel.xls'; /*Change it to MVS */

/*--------------------------------------------------------------*/
/* Use tagset Tagsets.MyPhtml as ODS destination to create      */
/* the HTML/XLS file                                            */
/*--------------------------------------------------------------*/
  ods listing close;
  ods Tagsets.MyPhtml body=htmlout (notop nobot) ;

  title;
  proc print data=sashelp.class;
    format weight height commax4.1;
  run;

  ods Tagsets.MyPhtml close;


Stéphane.

-----Message d'origine-----
De : SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] De la part de toby
dunn
Envoyé : samedi 12 février 2005 05:43
À : SAS-L@LISTSERV.UGA.EDU
Objet : Re: Excel engine in MVS


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,