Online File

How to use this page

---

Rick Aster: Professional SAS Programming Secrets: Contents

Chapter 10
Program 10m
Match merging with one observation per BY group

---

*
  Professional SAS Programming Secrets
  Program 10m
  Match merging with one observation per BY group
*;

options nocenter;
title1 'Starting Data: A';
data work.a;
   do x = 3, 5, 7;
      y = x + 10;
      a = 'A';
      output;
      end;
run;
proc print data=work.a;
run;

title1 'Starting Data: B';
data work.b;
   do x = 5 to 7;
      y = 2 + x/10;
      b = 'B';
      output;
      end;
run;
proc print data=work.b;
run;

title1 'Starting Data: C';
data work.c;
   x = 7;
   c = 'C';
   output;
run;
proc print data=work.c;
run;

title1 'Match Merge';
data work.merge;
   merge work.a work.b work.c;
   by x;
run;
proc print data=work.merge;
run;