12-06-2013 11:05 AM
I apologize if this is not the correct discussion group for this question; it seemed like the best choice.
I have an application written in C# that has a requirement to create sas data files, specifically the sas7bdat format. I'm trying to figure out what SAS integration options are available for doing so.
Thank you for your time. If our needs are unclear, please ask us to clarify.
12-06-2013 11:23 AM
See some references here:
These both use the SAS OLE DB data providers, which are available from support.sas.com. However, their primary purpose is for reading and perhaps updates, not as much for creating new SAS7BDAT files.
12-06-2013 07:54 PM
I'm not a C# guy, but one of my friends at Statistics Canada is!
Hope this helps you out.
12-06-2013 08:06 PM
What is the aversion to writing SAS code, or really writing a SAS code generating module in your C program?
Code to create a SAS dataset from a CSV file is trivial to write, especially if you limit the types of inputs that you need to support.
12-07-2013 11:55 AM
The question is unclear in its goal.
If you want just to deliver a file that easily can be read by users running SAS.....
- The csv file approach could be sufficient. But do not use comma as delimeters with a european relation using the decimal separators different.
- the transport-file could be sufficient although it is based on SAS-V6 .
This is the only public available description of a typical SAS data-structure. The internal sas7bdat structure is only open to dedicated partners like syncsort
This is pushing some pressure on release management of the SAS middleware (SAS system) as the structure of a sas7bdat is changing with SAS releases.
By the way,
- you could involve your C# code from a running SAS-session
SAS has stopped with their C-offering, but you can still find a lot
The SAS/toolkit software is still mentioned. but I have not seen any updates since SAS v6