SAS Version: 9.4 32bit (9.4 TS Level 1M5 | W32_7Pro platform) ODBC Redshift Driver: Amazon Redshift (x86) | 1.04.14.1000 Issue: When opening a Redshift table in the SAS Explorer, SAS looks like it's running, but ultimately freezes and I need to right click and close SAS. What is not an issue: I can query of the redshift tables just fine, pull data into a work dataset and view the info there. I can also view the columns of the redshift tables. Things I've tried / configurations: 1. Modified my SAS Connection libname x odbc dbmax_text=250 readbuff=250 noprompt= "Driver={Amazon Redshift (x86)}; Server=NONDESCRIPT_SERVER;
Database=NONDESCRIPT_DB; UID=NONDESCRIPT; PWD=NONDESCRIPT_PWD; Port=5439" schema=NONDESCRIPT_SCHEMA; I am able to connect to redshift , I can see the tables, I can right click and view the columns, but I'm unable to open the tables. The default field lengths were $1024 - using the dbmax_text I shrunk down to 250. Did not solve the issue. Added readbuff = 250. Did not solve the issue 2. Modified the ODBC Driver Using the Additional Options I selected "Use Declare/Fetch Caches Size: 100". The previous selection was "Retrieve Entire Result Into Memory" 3. Changed ODBC Drivers Amazon Redshift (x86) - My primary but still doesn't resolve the issue. DataDirect 8.0 Amazon Redshift Wire Protocol - doesn't resolve the issue. PostgreSQL Unicode - doesn't resolve the issue.
... View more
