proc report data = out.visitwindow11; column SubID Visit Visitdate AdminD ActualVW yellowflag; define Subid / "Subject"; define AdminD / "Drug Admin Date"; define ActualVW / "Actual Visit Window"; define yellowFlag / NOPRINT; Compute yellowflag; if Visit eq 'Follow-Up - Day 1 (+/-4h) (1)' and ActualVW > 1 then do; call define(_row_,'style', 'style=[background=mistyrose]'); end; if Visit eq 'Follow-Up - Day 3 (+/-24h) (1)' and ActualVW not in (2,3,4) then do; call define(_row_,'style', 'style=[background=mistyrose]'); end; if Visit eq 'Follow-Up - Day 6 (+/-24h) (1)' and (ActualVW) not in (5,6,7) then do; call define(_row_,'style', 'style=[background=mistyrose]'); end; if Visit eq 'Screening (-30 to -1)' and ActualVW > -30 then do; call define(_row_,'style', 'style=[background=mistyrose]'); end; if Visit eq 'Follow-Up - Day 28 (+/- 48h) (1)' and (ActualVW) not in (26,27,28,29,30) then do; call define(_row_,'style', 'style=[background=mistyrose]'); end; endcomp; run; The follow up visits are all highlighted.
... View more