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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.