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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.