/********************************************************************
 * Programmer: Alan Neustadtl                        Date: 10-02-00 *
 *                                                                  *
 * This program demonstrates the one-to-many match merging.         *
 *                                                                  *
 ********************************************************************/

data f1;
input idno alpha_a $;
datalines;
1 A
2 A
2 A
3 A
5 A
;
proc print;
run;

data f2;
input idno alpha_b $;
datalines;
1 B
2 B
4 B
;
proc print;
run;

data merge1;
merge f1 f2;
   by idno;
 proc print;
run;