Excel Automation

  • Savian can take existing processes that rely on SAS DDE or other technologies and create massively parallel Excel automated processes. Excel is not required to be on the server or machine. Savian uses a process that generates the Excel file directly.Savian also has a utility that will allow Excel files to be generated in the data step as PUT statements vs using DDE or other technologies. This provides much greater control over the layout.

Additional Microsoft Automation

  • PowerPoint Automation
  • Microsoft Project Automation
  • Visio Automation

Specific Services Experience

  • Architecture to Determine the Best Use of SAS
  • Determining Integration Points with Microsoft Technologies
  • Automated Office Solutions
  • Services Architecture
  • SAS Code Optimization
  • Appropriate Usage of SAS and Roles for .NET/Python
  • SAS Best Practices for Performance and Maintainability

SAS Analysis

  • SAS Logs
    Our analysis generates Excel worksheets that describe all aspects of what happened to help identify libnames, data sources, and resource usage

  • SAS Code Analysis
    • Create a flow of SAS programs to determine paths of execution
    • Determine performance issues
    • Code conversion
    • Web service enablement

  • SAS EG File Analysis
    • Determine flow of programs
    • Determine SAS code embedded in EG files
    • Determine inputs and outputs
    • Duplicate code analysis

  • SAS DataSet Analysis
    • Determine dataset metadata