Hello,everyone,who has a programming case for C++ to access the SAS dataset through ODBC ?, Could you send me one? Thank you every much.
From your previous questions, you shared that you are using Visual C++. I'll assume that you have access to the various Windows developer frameworks: MFC and/or ATL.
Remember that accessing SAS via ODBC is supported only if your data is on a SAS/Share server or in a SAS SPDS environment. You can't read a sas7bdat file directly -- for that, you use OLE DB.
Otherwise, use standard Visual C++ techniques for connecting to your SAS ODBC driver. See this topic on MSDN for a start.
No, see information about the SAS ODBC driver here, and its uses.
But what's wrong with using OLE DB? That's a standard approach that can work with Microsoft development tools. And we have a special book of "recipes" for different data access scenarios.
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!
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.