How do you use the SAS Macro facility to automate repetitive data processing tasks, and how do you debug a macro that is failing silently?