Home page
Company Info Services Our products Publiccation Associations
Delivering SAS Analytics to MS Excel and Word
Live Web Training
Course Overview
This course will show techniques and software to deliver SAS output and data to MS Excel and Word.  Some of the topics covered include: connecting between SAS and MS Office, authentification and secure access, delivering SAS programs and macros, managing macro parameters in Excel, delivering SAS datasets and sending SAS data in the form of Excel pivot tables.

    coupon code
The following software is required prior to attending the class. Some of the software will be supplied by the instructor while others is required on the student's machine.

Student's Requirements

  • Windows XP 
  • Internet Explorer or Mozilla Firefox 
  • Microsoft Office: Word and Excel
  • SAS version 8.12 or higher  

Download Available

  • Team Viewer - Desk sharing software for viewing course 
  • MXI Plugin - Connectivity software to deliver SAS data to MS Office

Latest download will be made available before week of class.

About Instructor

Sy Truong is the cofounder and president of MXI (Meta-Xceed, Inc.) since 1997. MXI provides software solutions within the Pharmaceutical Industry specializing in CDISC data standards, SAS validation, electronic submission, data analysis and reporting. Sy is one of the committee members of the Bay Area SAS User Group (www.basas.com). He is a frequent contributor and presenter at PharmaSUG, WUSS, and SUGI conferences. He's currently writing a book for SAS Publishing entitled Becoming a SAS Clinical Trials Programmer.

Course Introduction
The ubiquity of Microsoft Excel and Word on desktop computers has made it a default entry point for many users to view and edit their information. Once Excel was included into the MS Office suite in 1993, it became the killer app overtaking other spreadsheet heavy weights such as Lotus 1-2-3. Although Excel has analysis capabilities, it does not have the powerful statistical procedures and depth of SAS. There are two types of analysis that are being performed. One method is to use visual interactive spreadsheets to draw conclusions with Excel. The other method is to program SAS code to apply more nuanced statistical models. Many Excel jockeys do not have the knowledge or interest in learning to program in SAS since the interface of Excel is relatively easy to pick up. When analyzing certain types of data, such as financial information, Excel is the tool of choice. Its capabilities to easily generate graphs along with the visual pivot table provide powerful methods to view data. In certain cases, however, Excel is not capable of performing particular tasks which SAS can provide.

In the SAS programming camp, a common way to deliver dynamic reports is in the form of SAS macros. This gives the programmer the ability to parameterize specific views of the data and options for the selected statistical models. The challenge is that macros are developed by and used by programmers who are familiar with scripting programs rather than using the wizard GUI screens of Excel. This course will demonstrate tools and methods for SAS programmers to easily convert SAS programs such as macros into user friendly screens that MS Excel users can access directly from within Excel or Word. 

The software  used for demonstration will include MS Excel/Word, SAS 9.1.3 and MXI Plugin?. The gaps that exist between Excel and SAS users can be closed. The union of these tools enables power users and decision makers who may not be SAS programmers to fully explore the business data with the full analytical power of the SAS system.

     Meta-Xceed Inc. © 2016

SAS Cluster SAS Grid Cluster SAS Grid SAS SAS Cluster System SAS Cluster Servers SAS Grid Computing SAS Plugin for MS Office SAS MS Office Plugin SAS Plugin for Excel SAS Plugin for MS Word SAS Excel SAS MS Word SAS Macro Interfeace for MS Office Optimize Report Generation from CDISC Standards Generate Reports from CDISC Data SDTM Reports ADaM Reports Standard SAS Reports SAS Program Library SAS Macro Library CDISC Course CDISC Class SDTM Course SDTM Class CDISC Training CDISC Implementation Training CDISC Implementation Class MedDRA Training MedDRA Class WHO Drug Training WHO Drug Class AE Coding Training a href="training_thesaurus_coding.html">AE Coding Class Drug Coding Class Drug Coding Training DEFINE.PDF Training DEFINE .XML Training Domain Documentation Training Domain Documentation Class Data Definition Training Data Definition Class SAS Validation Training SAS Validation Class SAS System Validation Training SAS System Validation Class SAS Program Validation Training SAS Program Validation Class SAS Macro Training SAS Macro Class User Friendly SAS Macro Course User Friendly SAS Macro Training Programming Macro Training Programming Macro Class SAS Excel Course SAS Excel Training SAS MSOffice Course SAS MSOffice Training SAS MSWord Training SAS MSWord Course Change Control Training SAS Change Control Training SAS Program Change Control Training SAS Macro Change Control Training SAS Change Control Class SAS Program Change Control Class MedDRA Coding WHO Drug Coding MedDRA Coding Service WHO Drug Coding Service MedDRA Service WHO Drug Service Thesaurus Dictionary Management ADaM ADaM Consulting ADaM Service Analysis Datasets Analysis Datasets Consulting Analysis Datasets Service Annotated Case Report Form Annotated Case Report Form Consulting Annotated Case Report Form Service Annotated CRF Annotated CRF Consulting Annotated CRF Service Biostatistics Consulting Biostatistics Service CDISC ADAM CDISC ADAM Consulting CDISC ADAM Service CDISC Compliance CDISC Compliance Consulting CDISC Compliance Service CDISC SDTM CDISC SDTM Consulting CDISC SDTM Service Clinical Data Management Clinical Data Management Consulting Clinical Data Management Service CRF Design CRF Design Consulting CRF Design Service Data Management Service Design Case Report Form Design Case Report Form Consulting Design Case Report Form Service Discrepancy Management Discrepancy Management Consulting Discrepancy Management Service Edit Checks Edit Checks Consulting Edit Checks Service Electronic Submission Electronic Submission Consulting Electronic Submission Service SAS Consulting SAS Development Consulting SAS Development Service SAS Program Consulting SAS Program Service SAS Service SDTM Consulting SDTM Service Statistical Consulting Statistical Service Tables Listings and Graphs Tables Listings and Graphs Consulting Tables Listings and Graphs Service TLG Consulting TLG Service Coding Methodologies Contract Research Organizations CRO Data Library Managing Thesaurus Reconciling Dictionaries SAS Macros Table of Contents TOC Biostatistics Case Report Form Case Report Form Design Case Report Form Service CFR part 11 Clinical Data Management CRF Tabulations Custom Database Custom Database Consult font color="#FFFFFF">Custom Database Design Custom Database Service Data Analysis Data Management Data Warehouse Design Clinical Plans Electronic case report Electronic submission FDA Submission IND Medical Device Medical Writing Ndas Prepare Patient Profile Consult Patient Profile Generator Patient Profile Service RFP SAS Consulting SAS Service SOP Consulting SOP Service Code Optimizer Data Models Data Standards Data Definition Define.xml Define.PDF Domain documentation Data Definition Documentation Coded Terminology Coded Terminology Management Coded Terminology Software SAS Format SAS Format Management CDISC Coded Terminology Coded Terms Coded Terms Coded Terms Software Controlled Terminology Control Terminology Controlled Terminology Management Control Terminology Management Control Terminology Software Controlled Terminology Software CDISC Controlled Terminology CDISC Control Terminology SAS Data Viewer Data Viewer Syview View SAS without lock SAS Dataset Viewer SAS Dataset View SAS Data View Optimize Report Generation from CDISC Standards Generate Reports from CDISC Data SDTM Reports ADaM Reports Standard SAS Reports SAS Program Library SAS Macro Library