Large Scale Reporting Solution using SAS® and Excel
About this paper
In this paper, we discuss a use-case wherein every quarter a business wants to generate more than 1500 customized customer reports, so we have developed a tool which enables the business to generate the customer specific reports on a single-click and share the report(s) with the customer(s) over an email attachment. To achieve this, we use SAS Programming, SAS Add-In for Microsoft Office (MS-Office), VB Script and Think-Cell plugin for MS-Office. The final output is in the form of a MS-PowerPoint and PDF report which can be shared with the customer(s) via email and is accessible anywhere.
By the end of this paper, you will get an overview on using SAS Programming for large scale reporting purposes with the help of Output Delivery System (ODS) for Excel output and VB Script for converting excel data to MS-PowerPoint and PDF report.
About Core Compete
Founded in 2012, Core Compete is a pioneer in Cloud Analytics and is based in Durham, North Carolina with offices in Dallas, London and India (Pune and Hyderabad). We currently have 200+ employees and over 450 cloud and technology certifications, with highly specialized skills including: domain consultants, data scientists, and cloud engineers. Core Compete is an ISO 27001 and SOC 2 certified organization.
We partner with AWS, Google Cloud, Microsoft Azure, SAS, Snowflake, Hortonworks and Tableau to deliver successful cloud analytics and big data transformations for major corporations worldwide.