Sunderland manager Sam Allardyce describes the 1-1 draw at Newcastle in the Tyne-Wear derby as "hard to take" and says his team missed chances to score.