I have a EDC product solution built using java, which collects clinical trials data. Since we are a software product company we do not use or have SAS software license / installation in house. I am now trying to understand the best way to directly export this data from the EDC datastore to a SAS Dataset (.sas7bdat) format.
Any guidance on that would be highly appreciated.
The SAS dataset format is proprietary; since you're a company, you should get in touch with SAS and try to obtain a license (for the format, not just for a single SAS installation) and the proper documentation.
I also have a C# package on GitHub that does the xport format. It is a lot closer to Java than R or Python if you want to do a translation. It doesn't handle the most recent xport format since that one has a documentation issue on the SAS website. That may have been fixed.
I left the code in place in case you need to tackle it but it is not widely used (from what I saw).
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.