Hello,
I'm working with a dataset that has a list of action items where each action item has the owner name. Note that some owner has more than one action item.
My goal is to take the list of action items, divide them up by each owner, and email that Excel sheet to each owner. I'm pretty new to SAS Macros and I'm having difficulty thinking of what's the best way to do it. Currently, I'm writing code specific to each owner:
data ownername1;
set all;
if owner=owner1;
run;
data ownername2;
set alll
if owner=owner2;
run;
etc...
Then I'm going to proc export for each owner dataset and have SAS email out that report, however, I don't want an email to be sent if there are no action items. Clearly this is taking a lot of time and I can't help but think there's a better way to do this. Any ideas to get me started?
Thanks,
Derek
... View more