My advice (yes I tested and passed), for the exam, focus tight on the Content Guide. I think the SAS team did a good job scoping the exam to the guide.
In real life, know and understand that these other things exist. You may not use PROC SQL today, but if you stick with SAS you'll run across it and learning these other topics, even if you don't master them, is worthwhile.
Good luck.