topic Re: Access SAS Dataset using C# on .NET Core in SAS Programming

Access SAS Dataset using C# on .NET Core

AnandVyas — Thu, 01 Aug 2019 04:12:50 GMT

Hello Community members,

I am trying to access SAS dataset using C# code which I am successful using references from this blog post:

https://blogs.sas.com/content/sasdummy/2013/06/09/sas-client-with-microsoft-dot-net/

However we want to deploy our C# code to run on Linux Server using .NET Core framework. In this scenario, since there is no COM on Linux box is there any alternative to access SAS data set?

Any references to paper or blog would be helpful.

Thanks!

Re: Access SAS Dataset using C# on .NET Core

Ksharp — Thu, 01 Aug 2019 11:34:11 GMT

is it SAS Viya or

Does your SAS have IOM technology or

You could try JDBC to read sas dataset or

@ChrisHemedinger have some ideas .

Re: Access SAS Dataset using C# on .NET Core

ChrisHemedinger — Thu, 01 Aug 2019 12:24:51 GMT

Using IOM on a Linux box, you'd have to use the Java interfaces via CORBA. That's how SASPy works (access to SAS from Python). @Ksharp is correct - you would probably use JDBC to get to the SAS data.

Re: Access SAS Dataset using C# on .NET Core

nlivni — Wed, 04 Jan 2023 10:05:36 GMT

Hello, we have a similar requirement. only we just need to parse sas7bdat files in a linux container and nothing more. We have looked at the SAS Providers for OLE DB but they seem to only be available for windows. Is there a base image that we can use which has the minimum requirements to parse these files? We don't really care if its odbc,, jdbc, or anything else that is linux compliant. Would really appreciate any help.