Hi everyone,
I'm a beginner in using sas viya and sas studio. I try to connect our netezza database with cas server and also load certain files from netezza database to cas library. Codes are below, please feel free to point out how to correct it:
cas;
caslib casbox datasource=(srctype="odbc",
username="123",
password="123",
odbc_dsn="Nz_Analysis",
catalog="*");
libname casbox cas;
proc casutil outcaslib="mycaslib";
load data=casbox.table_right replace;
list files incaslib="casbox";
run;
LOG: only error is below:
Hi @alexal
Actually the problem is below. I tried several days to figure out how to do that.....
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" casout="CUN1";
run;
quit;
Hi @alexal
The whole log is below:
SAS Studio
I would suggest you open a track with our access team.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.