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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.