1. The manager of the bookstore wants to know which sales rep sold the most books in 2014. Use one or PROC SQL to find out. In the final table to present to the manager, include sales rep's name and the number of books sold in 2014. Also make sure the name shows up as first initial, space, and last name.Such As 'J Smith'. There may need to involve more than 2 datasets.

The below table contains the list of all six (6) datasets and their individual variables. Bolded variable names represent common variables with other datasets.

Customers	Items	List	Orders	Prices	SalesRep
fname	orderno	bookid	salesid	bookid	id
lname	bookid	title	custid	datefirst	name
address1	dateship	author	orderno	price	salesid
city	quantity	author2	dateord	datelast
stcode		yearpub
zip		isbn
custid
phone