Online File

How to use this page

---

Rick Aster: Professional SAS Programming Shortcuts: Contents

Chapter 45
Program
All possible key combinations

---

PROC SQL;
CREATE TABLE WORK.SIZES AS
    SELECT DISTINCT SIZE FROM WORK.STOCK;
CREATE TABLE WORK.STYLES AS
    SELECT DISTINCT STYLE FROM WORK.STOCK;
CREATE TABLE WORK.COLORS AS
    SELECT DISTINCT COLOR FROM WORK.STOCK;
CREATE TABLE WORK.COMB AS
    SELECT SIZE, STYLE, COLOR
    FROM WORK.SIZES, WORK.STYLES, WORK.COLORS
    ORDER BY SIZE, STYLE, COLOR;
QUIT;