load files in memory from odbc

michellekwai — Thu, 10 May 2018 15:31:09 GMT

Hi everyone,

I am a beginner in sas viya. I come across a problem: load files in the memory.

But I can connect to our odbc database successfully and I can see all files in caslib casbox too. Code below:

cas;
caslib casbox datasource=(srctype="odbc",
username="123",
password="123",
odbc_dsn="Nz_Analysis",
catalog="*");

proc casutil ;
list files incaslib="casbox";

load casdata="CUN1" incaslib="casbox" outcaslib="casuser"
casout="CUN1";
run;
quit;

ERROR: ERROR: ERROR: relation does not exist ANALYSIS.123.CUN1

ERROR: Function failed.

ERROR: The action stopped due to errors.

Any ideas to solve this problem? Thanks in advance!

Best,

Michelle

Re: load files in memory from odbc

JBailey — Tue, 29 May 2018 12:42:56 GMT

By chance are you using Netezza and 3 level table names?

Best wishes,
Jeff