07-15-2013 05:25 AM
I got the task to extract data from a sas7bdat-file, provided by a customer to use the data for further analysis.
As we are not using SAS, there is no instalation of any SAS product on our system.
I started configuring the OLEDB driver but found that it is not able to perform SQL-Statements later.
Now i am trying to configure ODBC driver (SAS_ODBC_Driver_9.3).
Currently I am facing the problem, that the ODBC driver seems to require sas.exe (please see attached screenshot).
Could anyone please tell me, if (and how) it is possible to configure the ODBC driver to load data from locally saved sas7bdat files?
Is a installation of SAS necessary? If yes, which product?
I hope anyone of you could help me as noone of our team has any experience with SAS yet ..
07-15-2013 08:06 AM
I think the universal viewer supersedes the one above and is for SAS 9.3 and earlier.
I dont really know if it will allow export of the data from the format or not but should allow you to open the file.
07-17-2013 03:49 AM
first of all: thanks for your help!
I just installed SAS Universal Viewer and saved the data as xml to get a first impression of the data in our tool.
Is there any possibility to open and save a file (sas7bdat to xml) with universal viewer via cmd.exe ?
I am currently searching in the documentation for any hint, but did not find anything until now.
If ODBC requires a SAS Server to be running, I have to send some requests to our customer to get information of their SAS infrastructure.
07-17-2013 07:44 AM
I would be surprised if the viewer has a command line interface built by SAS. Seems against its best interest to easy allow people out of there proprietary system easily. Seems to me if you are going to ask questions to your customer about their setup (which probably wont help you unless they are opening they network / system up to you for direct access), you should just ask for the files in a format you can use (as already stated in the some other replies).
I believe R does have a command line interface that may be useful for this and its an open source product which is free.
07-17-2013 10:42 AM
If you need to move SAS datasets to a server, its much easier if you have SAS, BASE SAS or DI Studio I suppose.
Or export from SAS datasets to text files. You can use an intermediary program such as R, but its another place to have errors pop up.
You may want to explain more of what you're trying to do if you want further help.
04-04-2014 03:52 AM
I'm not sure where how you are creating the OleDb connection, but it is perfectly possible to read SAS files without an installation of SAS using the Local provider.
It doesn't support SQL commands but you can still get all the schema information you need and open a DataReader.
04-04-2014 05:08 AM
remember the sas7bdat dataset type is a propierty format and not free published.
Seeing the tools as Stat/Transfer as a possible approach.
I remember once the exist the tool DBMSCOPY that one has been bought by SAS institute.
04-04-2014 06:15 AM
Agree on that Andre. I made the remark on propierty format for that reason. All third party interfaces are possible based on reverse engineering. You never know hitting something they missed.
As for data-exchange for incompatible systems it would be better using the XML format (adding zip) as that is designed for that purpose.
My advice would be: asking for XML version of the needed data