How to export data to ".sas7bdat" format from SQL Server or MS Access DB

Reply
Occasional Contributor
Posts: 8

How to export data to ".sas7bdat" format from SQL Server or MS Access DB

Hi,

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!

Ken

Super User
Posts: 5,260

Re: How to export data to ".sas7bdat" format from SQL Server or MS Access DB

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.

Data never sleeps
Super User
Posts: 17,912

Re: How to export data to ".sas7bdat" format from SQL Server or MS Access DB

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.

Occasional Contributor
Posts: 8

Re: How to export data to ".sas7bdat" format from SQL Server or MS Access DB

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?

Much appreciated!

Ken

Ask a Question
Discussion stats
  • 3 replies
  • 1104 views
  • 0 likes
  • 3 in conversation