SAS Integration Technologies - Data Provider
w/ IOM & ADO + all the rest of the typical letters
(Java, C/C++, J#, .NET...) Are free client side
components (free or free with specific licensed products).
One of the products provides read access to SAS Datasets
without SAS (in the Windows OLE Data Environment).
With IOM - read/write access to SAS Datasets is obtainable
between Windows OLE & a Unix SAS Server.
After working a few days and getting this working - I became
stymied trying to create/add a (new/additional) Libref to a
IOM Session. SAS Provides a Code Example Cookbook - for all
sorts of languages - VB, C/C++, .NET, etc - to do just this
but they are very specific and detailed for developers for
plenty of experience with those tools. Not tailored - for a
old SAS developer that's trying to expand/extend some needed
functionality. (as well as apotential proof of concept demo).
This would be somewhat old hat - except that SAS on Windows
is NOT used, and None of the SAS Add-ons are required -
(no SAS Access ODBC/PC File Formats, Share, EG, IntrNet)
I'm finding lots of NESUG/SUGI Papers, as well as the SAS
Documentation and Sample Cookbooks. However, they are either
dated and specific to old technology from 8.2 (back to the
oldest 6.12 origins) or too specific to experienced XXX coders.
The SUGI Presentation:
SUGI 27 Using SAS Data To Drive Microsoft Office,
Darren Key and David Shamlin,
References a working VB Project they created and made available
for the specific purpose of direct data exchange with MS Office
(aka MS Excel & MS Access). Of course, over the course of time
since SUGI 27 - the Web site download link has become broken.
"...The wizard add-in is implemented as a Visual Basic Add-In
project called SASOfficeWizard. (The source material for this
project is available on the Base SAS community web site:
http://www.sas.com/rnd/base.) A series of Visual Basic files
comprise the SASOfficeWizard project...."
I know this example will be dated - but starting with a working
example - from version 8.2, I believe I've picked up enough to be
able to modify/update it to work with 9.1.3 & IOM. If anyone has
the download package for the SASOFFICEWIZARD Project from this
SUGI (or similiar) presentation - can you somehow please make it
available to me ???
Likewise - if anyone has worked thru this ie exporting/importing
SAS Data w/ MS Access - using Integration Technology Tools - SAS
OLE DB Provider & IOM with either VB Script or VB - and has a
completed working VB Project / Script that I can copy/work from -
I'd really greatly appreciate it. Even other languages than VB
would be ok - much of the conversion for the specific steps is not
too obtuse - even for me (probably).
Not to be an advertisement - but if this posting has triggered any
further interest by anyone - below is a article list for further
-NESUG 2001 & SUGI 26 Migrating Your SAS ODBC Application To ADO
-SUGI 29 Bring the Data Warehouse to the Office w/ SAS Integration
-NESUG 2000 Developing an Open Client in Visual Basic, Daniel Jahn
-SUGI 28 Using IOM and Visual Basic in SAS Program Development,
-NESUG 2002 & SUGI 27 Using SAS Data To Drive Microsoft Office,
Darren Key and David Shamlin
-NESUG 2005 & SUGI 28 SAS in the Office. IT Works,
Peter Eberhardt M.A.
-Web Development with SAS by Example by Frederick E Pratter
SAS Integration Tools Suggested Reading List:
THANKS IN ADVANCE !!!