Hi, I have this code that works:
%let caslib = AAAA;
%let libname=SASHELP;
%let table=CARS;
cas mysess sessopts=(caslib=&caslib.);
caslib _ALL_ assign;
/* load */
proc casutil;
load data=&libname..&table.
outcaslib="&caslib." casout="&table." REPLACE;
run;
proc cas;
loadactionset / actionSet="dataDiscovery";
run;
dataDiscovery.profile result=r / table={name="&table."},
casOut={name="Profilazione", replace=true};
run;
but if i use this it gives me an error:
%let caslib = AAAA;
%let libname=SASHELP;
%let table=CARS;
cas;
libname &caslib. cas caslib=&caslib.;
/* load */
proc casutil;
load data=&libname..&table.
outcaslib="&caslib." casout="&table." REPLACE;
run;
proc cas;
loadactionset / actionSet="dataDiscovery";
run;
dataDiscovery.profile result=r / table={name="&table."},
casOut={name="Profilazione", replace=true};
run;
I just changed the bold part. Instead of allocating all CAS I allocate only one.
The error are:
ERROR: Could not connect to the Hadoop cluster. ERROR: Table 'CARS' could not be loaded. ERROR: Failure opening table 'CARS': A table could not be loaded. ERROR: The action stopped due to errors.
Thanks
Luca
... View more