Abstract Details
|
Activity Number:
|
257
|
|
Type:
|
Contributed
|
|
Date/Time:
|
Monday, August 5, 2013 : 2:00 PM to 3:50 PM
|
|
Sponsor:
|
Section for Statistical Programmers and Analysts
|
| Abstract - #307749 |
|
Title:
|
A Primer for Integrating Microsoft Excel, Access, and SAS
|
|
Author(s):
|
Martin Selzer*+
|
|
Companies:
|
Genzyme
|
|
Keywords:
|
Applications Development ;
VBA ;
SAS ;
MS Access
|
|
Abstract:
|
Applications development most often involves a platform for form creation and computations with data from one or more databases. The following essay describes how to use Microsoft Visual Basic for Applications in Excel as a form and computation platform with Microsoft Access as a data repository and SAS as a data retrieval and processing application. It assumes VBA code and the Access database runs on a local DOS server. SAS programming and file access includes execution of code on a local server and/or remote execution on a Unix server. The intent is to provide a clear description of how Excel VBA, Microsoft Access, and SAS can be integrated in one application. Code examples are given to help implement methods described.
|
Authors who are presenting talks have a * after their name.
Back to the full JSM 2013 program
|
2013 JSM Online Program Home
For information, contact jsm@amstat.org or phone (888) 231-3473.
If you have questions about the Continuing Education program, please contact the Education Department.
The views expressed here are those of the individual authors and not necessarily those of the JSM sponsors, their officers, or their staff.
Copyright © American Statistical Association.