Both the left and right tables have been standardized. There are 63 rows in the left table, and 31 rows in the right one.
A Data Join node (right join) was applied successfully. But the log shows there were 33 rows joined. Does it make sense to have 33 rows joined instead of 31?
Things to consider ... perhaps ...
It's almost certainly a result of what's in the data, combined with the joining criteria.
Things to consider ... perhaps ...
It's almost certainly a result of what's in the data, combined with the joining criteria.
A test to understand
data left;
do key_l=1 to 61;
if key_l=31 then do _n_=1 to 3;
output;
end;
else output;
end;
run;
data right;
do key_r=1 to 31;
output;
end;
run;
proc sql;
create table w as
select *
from left right join right
on key_l=key_r;
quit;
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.