/* Jump to: Chapter 14 Table of Contents */
LIBNAME mylib 'c:\temp';
PROC SQL;
CREATE TABLE mylib.class
( Name char(8),
Sex char(1),
Age num,
Height num,
Weight num
)
;
INSERT INTO mylib.class
VALUES ("Alfred" , "M", 14, 69.0, 112.5)
VALUES ("Alice" , "F", 13, 56.5, 84.0)
VALUES ("Barbara", "F", 13, 65.3, 98.0)
VALUES ("Carol" , "F", 14, 62.8, 102.5)
VALUES ("Henry" , "M", 14, 63.5, 102.5)
VALUES ("James" , "M", 12, 57.3, 83.0)
VALUES ("Jane" , "F", 12, 59.8, 84.5)
VALUES ("Janet" , "F", 15, 62.5, 112.5)
VALUES ("Jeffrey", "M", 13, 62.5, 84.0)
VALUES ("John" , "M", 12, 59.0, 99.5)
VALUES ("Joyce" , "F", 11, 51.3, 50.5)
VALUES ("Judy" , "F", 14, 64.3, 90.0)
VALUES ("Louise" , "F", 12, 56.3, 77.0)
VALUES ("Mary" , "F", 15, 66.5, 112.0)
VALUES ("Philip" , "M", 16, 72.0, 150.0)
VALUES ("Robert" , "M", 12, 64.8, 128.0)
VALUES ("Ronald" , "M", 15, 67.0, 133.0)
VALUES ("Thomas" , "M", 11, 57.5, 85.0)
VALUES ("William", "M", 15, 66.5, 112.0)
;
QUIT;
/* Jump to: Top of Section Top of Chapter */