CODEWITHSUNDEEP
c#sql-servert-sqlsas
Giuseppe
Giuseppe

Reputation: 655

SAS readable files from C# and TSQL

I have a C# application that reads data from a MS SQL Server database. What I need to do is to create a class that

In other words : I need to produce a .SAS7BDAT file from a DataTable inside C# which contains data from a SQL Server database.

Can anyone help? Thanks

Upvotes: 0

Views: 865

Answers (1)

Joe
Joe

Reputation: 63424

This isn't possible without SAS, or a custom library not freely available.

SAS provides OLEDB drivers for this purpose, but they require a SAS installation (of various sorts), as referred to in this table. You can read SAS7BDAT with the free local provider, but not write.

CozyROC sells a SAS compatible .NET library that allows you to write to SAS directly. That's the only way I'm aware you could do this. Alan Churchill has done this also on his own (decoded the SAS7BDAT format), but I suspect he sold his work to CozyROC since he now links to them.

Upvotes: 1

Related Questions