topic Re: SAS SQL Library for C in SAS Programming

SAS SQL Library for C

LXL — Tue, 27 Mar 2018 06:32:18 GMT

Hello everyone,How can I use SAS SQL Library for C to get sas data by C++? please heip me,thank you every much.

Re: SAS SQL Library for C

andreas_lds — Tue, 27 Mar 2018 07:45:26 GMT

Sorry, but don't understand what you plan to do.

Re: SAS SQL Library for C

LXL — Tue, 27 Mar 2018 08:01:48 GMT

Thank you for your reply. I want to use vs c++ to access the SAS dataset by using SAS SQL Library for C,but i do not know how to use it .Do you know how to use it ?

Re: SAS SQL Library for C

Kurt_Bremser — Tue, 27 Mar 2018 08:08:16 GMT

Find information here: https://support.sas.com/downloads/package.htm?pid=2171

You need a SAS/SHARE and SAS/IntrNet license and a properly set up SAS/SHARE server.

Re: SAS SQL Library for C

LXL — Tue, 27 Mar 2018 08:29:25 GMT

Thank you,I know this,and i have downloaded this library,but i do not know how to use this library.Can you tell me how to use it in details? Thank you very much.

Re: SAS SQL Library for C

Kurt_Bremser — Tue, 27 Mar 2018 09:16:36 GMT

After installation, I'd go looking for the .h header files and the .a or .so library file(s). Add the path to the library files to your LIBPATH environment variable, so the compiler can pick it up.

Re: SAS SQL Library for C

ChrisHemedinger — Tue, 27 Mar 2018 11:37:28 GMT

Can you tell us about your final objective? Are you trying to read a local SAS data set or a remote data set from a SAS server? SAS has packaged two OLE DB data providers -- one for local and one for remote (Integration Technologies). These can be easily incorporated into custom Windows applications. You can use SQL syntax to address/filter data.

See some examples here:

https://blogs.sas.com/content/sasdummy/tag/ole-db/

And here:

Create your own client app with SAS Integration Technologies

Re: SAS SQL Library for C

LXL — Wed, 28 Mar 2018 05:46:45 GMT

OK,Thank you very much,you are so kind.

Re: SAS SQL Library for C

LXL — Wed, 28 Mar 2018 05:57:17 GMT

hello,I wnat to use VS C++ to access the SAS dataset ,the method is optional,the simpler is the better,do you know about using ODBC or OLEDB to acess the data,which is easier to reach my goal? Could you provide some references about this to me ? Thank you very much.

Re: SAS SQL Library for C

LXL — Fri, 30 Mar 2018 02:48:52 GMT

Could you tell me that what is the easiest method for me to use VC++ to acess SAS dataset? Thank you every much.