O'Reilly logo

Exchanging Data From SAS to Excel by William E. Benjamin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4: Setting Excel Document Property Values

Options to Modify the Excel Document Properties Sheet

Default Excel Property Sheets

Modify Excel Property Sheets with the ODS EXCEL Destination

Excel Property Sheet Date/Time Fields without the SASDATE Option

Excel Property Sheet Date/Time Fields with the SASDATE Option

Conclusion

Introduction

This chapter addresses ODS EXCEL destination options that enable you to enter text into the “Excel Properties Sheet” directly from SAS. This is a time-saving option that enables you to update properties at the same time that your workbook is created. This also eliminates the need to explain why your workbook was modified after it was created. All of the options described in this chapter accept a text string ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required