I think the closest you can come to closing or canceling the account would be to call Sony and ask them to delete it.
If it was me, I'd just make sure it didn't have my credit card stored in it and ignore the account.
If you do either of those things your books will just sit there in the latter event, or go away in the former.
The only way you could transfer the books to someone else would be to transfer the
account to someone else. What I mean is remove your credit card info if you've entered it (unless you want them to keep buying new books on your nickel, of course), change the e-mail address on the account to the other person's address, and change the password to something you and they have agreed upon. Oh, yeah, don't forget to de-authorize the PC you're working on!
Then the other person could log into the Sony store using their e-mail address and the password you set (they can change it afterwards) and the account, with all its books, would then be "their" account.
Hope that helps.