ODS and Office Integration

ODS and Office Integration

SAS Global Forum, 2007.


The growth of ODS destinations has provided many choices when it comes to getting your SAS® output into your favorite spreadsheet or word processor. Find out the various and best ways ODS integrates with Microsoft® Office and OpenOffice.org. Putting SAS output into documents and spreadsheets has never been so good or so easy. 

'ODS and Office Integration' is all about choices. Some people are happy with pdf files, some like HTML. Maybe  Microsoft Word is your preferred way to look at SAS Reports, or even better, Excel. Then you can play with the numbers and see what could be.

At the time, a co-worker of mine always joked that ODS markup and tagsets were going to take over the world. While tagsets are not done yet, they have taken over almost every renderable output that SAS ODS creates. Come along for the ride with Pinky and the Brain, while we exlpore the possibilities that ODS markup presents. The decision of which of them is the genius and which is insane is left up to you.

Something that I find interesting is that this paper is from 2007 and even then, XML was still something to be considered. These days XML is used by Microsoft, Open Document Format and SAS, but has lost favor to JSON.  It seems to me that these large corporations and foundations become so entrenched with their direction that they cannot see ahead or adjust when something better comes along. XML is still a nice way of marking up data. It will work well for Microsoft office and ODF. I do question its validity when it comes to exchange formats like SAS Report, which resorted to embedding CSV, and its successor, which promises to be fully rigid in its implementation as XML. Whatever the answer, I'm sure Brain or Pinky would have an opinion. Narf!

Whatever it is you want, ODS can deliver what you need. It may not always be perfect. But ODS can get you in the ballpark. This paper, like many of my papers, is all about seeing the possibilities. 

Get the paper and the example code!

Everything is available in my GitHub repositories.

This paper, as with all of my SAS papers, is available from my SAS-Papers github repository. The example code for this paper can be found in my SAS-Examples github repository.

Leave a Reply

Your email address will not be published. Required fields are marked *