We have a telephone surveying tool called Blaise® (a powerful computer-assisted interviewing (CAI) system and survey processing tool for the Windows® operating system) All the surveyed data is collected into this system and processed into SAS. Currently we create ASCII files from Blaise to import into SAS. Going forward we would like to be able to connect directly to the Blaise database from within SAS. Is this possible. There are some Blaise API I read about, can I call these from within SAS. Or can I use SAS/Access to be able to connect to the Blaise system. If you can point me to any lead that would give me good start.
In addition, it looks like Blaise has a way to create SAS data descriptions with a product called Cameleon:
Cameleon is a meta data system and language that can recast Blaise data descriptions into one for SAS, SPSS, or other statistical packages or database languages. You can also use Cameleon to create customized translation setups for your organization's needs.
I don't know whether you can connect directly to the Blaise database with SAS. This is a question for Blaise Technical Support. It depends on whether the Blaise database is a standard database (such as Oracle, or DB2, etc) or whether the Blaise database is accessible via DDE or ODBC or OLE-DB.
SAS/Access allows connections via many standard data base formats (via Oracle, Sybase, DB2, etc) and also allows connections to be made via ODBC and OLE-DB. You would have to find out whether Blaise supports either ODBC calls or OLE-DB calls and/or whether Blaise uses a standard database system that is supported by a SAS/Access interface.
Thank you Cynthia.
True we can use Cameleon for export into SAS from Blaise. But we would like to give more control to the SAS programmers to be able to pull data from Blaise. (What we are hoping for is to read the Blaise dataset directly from SAS without creating files like txt or XML as a middle step).
One of the Blaise developers in my firm told me that there may be a way to access data from the Blaise System if you can call Blaise API from SAS. I am assuming it would be similar to the windows API. If you can guide me to how to open/call APIs from within SAS, I think this would be a good starting point.
thank you again.