@SASJedi wrote:
This turns out to be a problem with the SAS Online Docs. The use of data set options for loading a hash object is not supported in CAS. I've reached out to the documentation team and expect to see a note added to that effect in the next documentation update when it is published next month.
@acordes Based on above removing the data set options from your code should resolve the issue.
%let mov_minutes1=10;
%let mov_minutes2=30;
%let incas=public;
options mlogic symbolgen merror;
data PUBLIC.X_TEST1(drop=_rc copies=0 replace=yes );
if _N_ = 1 then do;
/* create variables */
if 0 then
do;
set
CASUSER.TESTER1
PUBLIC._MOVE_BATCH3_TR(keep=name BATCH_ID movave3_batch movstd3_batch)
PUBLIC._MOVE_MIN10_TR (keep=name movave10 movstd10 BATCH_ID datetime)
PUBLIC._MOVE_MIN30_TR (keep=name movave30 movstd30 BATCH_ID datetime)
;
end;
/* define hash tables */
declare hash h_summary_a1(dataset: "&incas.._MOVE_BATCH3_TR");
h_summary_a1.defineKey('batch_id', 'name');
h_summary_a1.defineData('movave3_batch', 'movstd3_batch');
h_summary_a1.defineDone();
declare hash h_summary_a2(dataset: "&incas.._MOVE_MIN&mov_minutes1._TR");
h_summary_a2.defineKey('batch_id', 'name', 'datetime');
h_summary_a2.defineData("movave&mov_minutes1.", "movstd&mov_minutes1.");
h_summary_a2.defineDone();
declare hash h_ndist_a2(dataset: "&&incas.._MOVE_MIN&mov_minutes2._TR");
h_ndist_a2.defineKey('batch_id', 'name', 'datetime');
h_ndist_a2.defineData("movave&mov_minutes2.", "movstd&mov_minutes2.");
h_ndist_a2.defineDone();
end;
call missing(of _all_);
set CASUSER.TESTER1;
/* lookup */
_name_=name;
_rc = h_summary_a1.find();
_rc = h_summary_a2.find();
_rc = h_ndist_a2.find();
drop _name_;
run;
... View more