ODS HTML BODY = ' booklist.html

LIBNAME SQL ' e:\ library datasets \ '；

proc sql NOPRINT

Create table Avglist as

Title "Report on the Average Price of Library Books";

Create table

choose

Mean(BookPrice) format = dollar 18. As the average price

From sql.library

Sort by book number

Group by category;

Quit;

PROC print data = Avglist NOOBS；;

Running;

ODS HTML closed;