09-12-2014 12:30 PM
I am sure this question may have been asked by other before but we have web based application that uses SQL Server as the backend. We would like to give our clients the capability to directly export data in the ".sas7bdat" format. Is it possible to do so with a "one click" export to SAS format? We have been able to do so with CSV and Excel but trying to find out how we can do so for SAS. I believe there is also the SAS/Access module available but it is too expensive. I am looking for an alternative solution.
Any feeback/comments/advice is greatly appreciated!
Thanks in advance!
09-12-2014 01:28 PM
The SAS file format is proprietary to SAS Institute, so I don't think that there is any legal/free tool that will give you this.
If you wish to have SQL Server as master, then SAS/ACCESS is not the best fit.You probably need a SAS server solution which could be accessed by ODBC or OLEDB.
My suggestion that you check with a SAS sales representative, present your case and hopefully they will be able to recommend a set-up for you.
Who are your clients? How do they work with SAS data? I can see it would be nice to go directly to SAS dataset, but it's quite easy to import csv in SAS, and it's always included in your clients SAS license.
09-12-2014 04:49 PM
You can give them access to the SQL server instead, with ODBC license from SAS on their end. That way they use the tables on the server and get the power of the SQL server as well.
09-15-2014 12:13 PM
Thanks so much for your replies, Reeza and LinusH. I have heard that ODBC drivers are now part of the recent versions of the base SAS program. Can anyone confirm this? Also, from what version onwards have the drivers been included with base SAS?