Date:         Sun, 19 Jul 2009 07:47:27 -0700
Reply-To:     Joe <ejmcknigh@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe <ejmcknigh@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Excel
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

I currently use SAS on the mainframe and have SAS job that creates a
CSV file. The file is uploaded to a server where the users view the
file in Excel. I'm making changes to the SAS program and need to
create a new file that when opened in Excel will provide two
worksheets instead of just the one.

The only way I believe to do this is to change the file format from
CSV to XML. I'm not familar with the XML format and need assistence on
how to create a file using this format in a SAS mainframe program.  I
was told that ODS could do this, but I've never used ODS in a
mainframe SAS program.

If anyone has examples they could provide on how ODS and XML is used
in mainframe SAS I would very much appreciate the help.

Thank you!