Transcription of Using SAS ODS Create Excel Worksheets - SAS Support
{{id}} {{{paragraph}}}
1 Paper SAS710-2016 More Than Just a Pretty Face: Using the SAS Output Delivery System to Create Microsoft Excel Worksheets That Answer Those Difficult Questions Chevell Parker, SAS Institute Inc. ABSTRACT Microsoft Excel Worksheets enable you to explore data that answers the difficult questions that you face daily in your work. When you combine the SAS Output Deliver System (ODS) with the capabilities of Excel , you have a powerful toolset you can use to manipulate data in various ways, including highlighting data, Using formulas to answer questions, and adding a pivot table or graph.
can identify trends in data by using SAS macros, macro variables, or SAS formats. For example, the next code example uses a SAS format to specify a range of values, and it includes a hook in the CSS file to use the format in a style property. The hook is shown here. In Example 3, the CSSSTYLE= option imports the CSS file.
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}