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
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.