FriedEgg:  Just an FYI: the author of that sasCommunity.org page happens to be a Discussion Forum participant as well.  I'm surprised that he hasn't participated, as yet, in the present discussion. ... View more

/*Dataset A*/ data A; input name $; cards; john tom emily ; run; /*Dataset B*/ data B; input ID; cards; 34 54 67 ; run; /*using cross join to perform one-to-many match*/ proc sql; create table C as select * from A,B; quit; /*print the dataset C*/ proc print data=C; run; Regards, Vishnu ... View more