Hello,
First post... I am a new SAS user, and am trying to connect using ODBC...I can use a LIBNAME statement to connect via ODBC, and I can see the data tables, view the records, etc., however, when I use a DATA statement to pull the data in, it will read all of the data in, and then throw this error:
ERROR: CLI cursor extended fetch error: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0501
- Cursor SQL_CUR0ABB58E0 not open.
Any idea what I am perhaps doing wrong or have configured incorrectly? Thank you.
Are you accessing a table or a view?
Can the view successfully execute on the server side?
Here is the code I try to execute (password replaced)
LIBNAME PROD ODBC USER = 'mperva' PASSWORD = 'XXXXXXX' DATAsrc='Production' SCHEMA = 'OLYDBF';
DATA TEST;
SET PROD.IDCS;
RUN;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.