Hi Patrick, very interesting solution, I like it. It works when I use one one variable, and gives the same rulst like an inner joint function. But it files the fault below, when I try to do it with both variables. I have yet to find out why. data Kea.Trail1_102;
if _n_=1 then
do;
dcl hash h1(dataset:'Kea.testdata10 (keep= REFER_ID CL_ID)');
h1.defineKey('REFER_ID' 'CL_ID');
h1.defineDone();
end;
set Kea.Trails_file_1;
if h1.check()=0 then output;
run;
401 data Kea.Trail1_102;
402
403 if _n_=1 then
404 do;
405 dcl hash h1(dataset:'Kea.testdata10 (keep= REFER_ID CL_ID)');
406 h1.defineKey('REFER_ID' 'CL_ID');
-------
22
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=,
<>, =, >, ><, >=, AND, EQ, GE, GT, LE, LT, MAX, MIN, NE, NG, NL, OR, ^=, |, ||,
~=.
407 h1.defineDone();
ERROR: DATA STEP Component Object failure. Aborted during the COMPILATION phase.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
408 end;
409 set Kea.Trails_file_1;
410 if h1.check()=0 then output;
411 run;
... View more
