I've searched high and low and can't find an answer to this problem, and had just responded to Rick Wicklin's last post on PROC DOCUMENT. An example will illustrate the problem I'm having. Suppose a clinical trial with 5 subjects (DM), and only 1 of whom has an AE (subject 3). data demog; input usubjid @@; age = 70; cards; 1 2 3 4 5 run; data ae; input usubjid evt $ @@; cards; 3 AE1 3 AE2 3 AE3 ; run; What I'd like to end up with, via ODS PDF, is to generate the TOC after I run PROC PRINT or PROC REPORT for each subject (grf1.jpg). Now I can easily achieve this using ODS and PROC DOCUMENT if I process each subject in a loop, by naming the objects and directing them to folders and so forth. What I am unable to do is to repeat if, instead of a macro going subject by subject, I try to use a BY statement, which would be much more efficient than a looping a macro. The problem that I face, and can't solve, is that subject 3, in AE, is the first patient to have AEs, so this gets assigned ByGroup1#1 (see grf2.jpg). No matter how I try to move things around, it seems I can't get the 1:1 match between AEs and DM that I want, using the by groups. One can imagine the challenges when we have different domains not having a 1:1 match for subjects (CM (conmeds) CE (events), etc.). Thanks - if you'd like to see how I handled this with macros and looping, I can share it. Dan.
... View more