Online File

How to use this page

---

Rick Aster: Professional SAS Programming Shortcuts: Contents

Chapter 53
Program
Creating an observation-number lookup table

---

PROC SUMMARY DATA=TABLE1;
   VAR KEY;
   OUTPUT OUT=MAXKEY MAX=MAX;
RUN;
DATA N (KEEP=KEY) / VIEW=N;
   SET MAXKEY;
   DO KEY = 1 TO MAX;
      OUTPUT;
      END;
RUN;
DATA TABLE2 (DROP=KEY);
   MERGE N TABLE1 (IN=IS);
   BY KEY;
   VALID = IS;
   LENGTH VALID 3;
RUN;