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