Creating highly customized binary excel files using xml 99 3 of the time
This presentation is the property of its rightful owner.
Sponsored Links
1 / 10

Creating highly customized, binary Excel files using XML… 99.3% of the time PowerPoint PPT Presentation


  • 40 Views
  • Uploaded on
  • Presentation posted in: General

Creating highly customized, binary Excel files using XML… 99.3% of the time. “42.7 percent of all statistics are made up on the spot.” – Steven Wright. Alan Churchill, Savian, LLC Don Henderson, HCSBI. [email protected] [email protected] Scenario.

Download Presentation

Creating highly customized, binary Excel files using XML… 99.3% of the time

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Creating highly customized binary excel files using xml 99 3 of the time

Creating highly customized, binary Excel files using XML… 99.3% of the time

“42.7 percent of all statistics are made up on the spot.” – Steven Wright


Alan churchill savian llc don henderson hcsbi

Alan Churchill, Savian, LLCDon Henderson, HCSBI

[email protected]@hcsbi.com


Scenario

Scenario

Replicate these every day using my data from SAS…

I need this done fast

  • Client would like a lot of Excel reports created by SAS and they are highly customized (formats, graphs, printing options, etc.)

  • Customer


Example report

Example Report


What are the sas options for doing this

What are the SAS options for doing this?

  • DDE, proc export, libname engine

    • Old and can be difficult to work with (DDE)

    • May not support newer Excel features and versions

    • May require a separate license to create binary files

  • ODS using proc report and the ExcelXP tagset

    • Complicated

    • Close in many cases…but not close enough

    • Very labor intensive

    • Does not generate binary workbooks

    • Does not handle Excel graphs


Savicellspro scp

SaviCellsPro (SCP)

  • SCP is Windows-based.

  • Supports native Excel binaries in 2003 & 2007 format

  • Uses a template for the Excel layout which is then fed into the SCP engine

  • Supports Excel graphics

  • SAS can be used on any platform to modify the template and insert data

  • Companion tool generates template from existing workbook


Scp process for solving problem

SCP Process for Solving Problem

One time processes

Tune code


Demo time

DEMO TIME


Scp negatives

SCP Negatives

  • Windows-centric

  • Does not handle proc output. SCP’s intent is to create ‘customized’ workbooks

  • Has to be executed from a command prompt or via the X command in SAS


Alan churchill savian llc don henderson hcsbi1

http://www.sascommunity.org/wiki/SaviCellsPro_-_SGF_2010

Alan Churchill, Savian, LLCDon Henderson, HCSBI

[email protected]@hcsbi.com


  • Login