Hello,
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.
Notes:
Thank you for your time. If our needs are unclear, please ask us to clarify.
See some references here:
Peek at your data using VBScript, OLE DB, and the SAS local data provider - The SAS Dummy
Using Windows PowerShell to view your SAS data dictionary
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.
Chris
I'm not a C# guy, but one of my friends at Statistics Canada is!
Hope this helps you out.
Tom
http://support.sas.com/resources/papers/proceedings12/017-2012.pdf
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.
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 .
TS-DOC: TS-140 - THE RECORD LAYOUT OF A DATA SET IN SAS TRANSPORT (XPORT) FORMAT
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
40562 - Defining a C function and calling it from the SAS® System
SAS has stopped with their C-offering, but you can still find a lot
Introduction to the SAS/C C++ Development System : Overview of the SAS/C C++ Development System
The SAS/toolkit software is still mentioned. but I have not seen any updates since SAS v6
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.