Date:         Thu, 14 Jun 2007 20:45:08 -0400
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: footnote in proc tabulate

On Thu, 14 Jun 2007 03:15:25 -0400, Kelvin <kelvinity@GMAIL.COM> wrote:

>I would like Proc Tabulate to include a footnote only for tables which
>contain cell values equal '1000'. Can this be done? Any advice is
>appreciated. Thanks.

There's probably a way (or two) using ODS. I'll leave that for somebody else.

I would use PROC SUMMARY to do all of the aggregation, then run a DATA step
against the output to test for the critical condition and use a conditional
CALL EXECUTE to set up the footnote. Finally, run PROC TABULATE against
either the original or the summarized data.