Online File
Rick Aster: Professional SAS Programming Shortcuts: Contents
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;