I suggest looking up the papers, especially Hands On Workshops from the SAS conferences on the support.sas.com website.
The workshops should include worked examples of creating a macro to resolve a particular problem.
I also favour the Technical Support note area on the SAS website. There are many subject areas, macro and base issues are among those dealt with at
http://support.sas.com/resources/papers/tnote/tnote_base.html.
I like Michele's style of writing. But I don't think you can ever go wrong with any book from SASPress.
Kind regards
David