Online File

How to use this page

---

Rick Aster: Professional SAS Programming Secrets: Contents

Chapter 10
Program 10j
Selecting one observation per BY group

---

*
  Professional SAS Programming Secrets
  Program 10j
  Selecting one observation per BY group
*;
proc sort data=work.customerlist out=work.customersort;
   by customer transaction_count purchase_total contact_date;
run;
data work.customer work.customerdup;
   set work.customersort;
   by customer;
   if last.customer then output work.customer;
   else output work.customerdup;
run;