John, Not truly my area of expertise. I know it works. But from the z/OS Companion for SAS has a description.
The SAS Output Delivery System can be used to generate graphical reports of your SAS data. Remote browsing enables you to view your output directly from the SAS session, either in real time as the output is generated, or on demand from the Results window. Remote browsing displays ODS output that is generated to z/OS native data sets (sequential, PDS, or PDSE) or a UFS directory. HTML, PDF, RTF, and XLS file types are displayed with the remote browsing system. If your browser does not have the appropriate plug-in for non-HTML data types, it will display a download dialog box rather than the actual data. This dialog box will enable you to download the report to your PC and view it using a local program, such as Excel for an XLS file. Note: When images or graphics are written to az/OS native data set and remote browsing is being used to view the output, the URL=NONE option should not be used with the ODS statement. Using this option causes the HTML to be written with incomplete filenames, and the remote browsing system is not able to determine the location of the image or graphics. When this situation occurs, the browser displays broken image icons in the HTML output. You might find it helpful to save another software vendor's file to a DBF file and then convert that file into a SAS data set. For example, you could save an Excel XLS file in DBF format, upload the file, and use PROC DBF to convert that file into a SAS data set. Or you could do the reverse; use PROC DBF to convert a SAS data set into a DBF file and then load that file into an Excel spreadsheet. The process I have used is to generate an RTF file on the mainframe and then using SAS EMAIL process, email that result. Then when my recipients open the email, the RTF shows up in the Browser. I have seen several SAS papers on Mainframe to Excel processes. SAS also has a Microsoft plugin that allows you to use SAS to extract the data you want while in Excel prior to allowing Excel to present the data. Basically you write the output from SAS in a different format (XLS, RTF, HTML, PDF, RTF) to an HFS or PDSE file (I have not worked with ODS with other file types). And it "works". I do not know how the ODS engine works to make the magic happen. If you would like a sample SAS code, write me offlist and I will share. Lizette > > Thanks for the correction. That is a "real" XLS file, not just a file which can be opened > in Excel (like CSV can be opened in Excel)? > > -- > John McKown > Systems Engineer IV > IT > > Administrative Services Group > > HealthMarkets(r) > > 9151 Boulevard 26 * N. Richland Hills * TX 76010 > (817) 255-3225 phone * > [email protected] * www.HealthMarkets.com > > Confidentiality Notice: This e-mail message may contain confidential or proprietary > information. If you are not the intended recipient, please contact the sender by reply > e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand > name for products underwritten and issued by the insurance subsidiaries of > HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National > Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance > Company.SM > > > > -----Original Message----- > > From: IBM Mainframe Discussion List [mailto:[email protected]] > > On Behalf Of Lizette Koehler > > Sent: Friday, September 14, 2012 9:38 AM > > To: [email protected] > > Subject: Re: Creating .xls on z/OS > > > > John, > > > > I have used ODS in SAS and you can generate the XLS into a PDSE file > > that is then send (via email or other FTP to a site) very easily. > > > > From the ODS manual > > > > With ODS, you can produce tabular output , which can be viewed with > > Excel. > > D\ > > > > > > > > Lizette > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
