Date: Fri, 6 Feb 2004 22:24:55 -0500
Reply-To: Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Subject: Re: Bolding one observation every time it appears
Content-Type: text/plain; charset=ISO-8859-1
See "PROC REPORT: Doin’ It in Style!" by Ray Pass and Sandy McNeill
http://www2.sas.com/proceedings/sugi28/015-28.pdf
On Fri, 6 Feb 2004 19:02:01 -0500, Pat Moore <pat.moore@UAA.ALASKA.EDU>
wrote:
>Is there any way to bold one observation whenever it appears in a report?
>I'm using proc report, and one of the lines needs to be bolded every time
>that observation appears. The data look like this (thanks, Art Tabachneck
>and Phil Crane):
>
>
>id _NAME_ AY99 r99 ay00 r00
>123 Measure1 12345 2 67890 1
>456 Measure1 98765 1 54321 2
>123 Measure2 78901 1 67895 2
>456 Measure2 66554 2 99887 1
>
>I read it with this:
>
>proc report data=report9802 nowd;
> column id _name_
> ('AY 1998-99' ay99 r99)
> ('AY 1999-00' ay00 r00)
> define id / group ' ';
> define measure / group noprint;
> define ay99 / 'Value' f=comma8.;
> define ay00 / 'Value' f=comma8.;
> define r99 / 'Rank';
> define r00 / 'Rank';
> break after _name_ / page;
> compute before _page_ / style= {just=l font_weight=bold};
> line 'Measure: ' _name_ $itemf.;
> endcomp;
>run;
>
>Output looks like this:
>Measure: Measure1
>id AY99 r99 ay00 r00
>123 12,345 2 67,890 1 *I want this line boldfaced;
>456 98,765 1 54,321 2
>123 78,901 1 67,895 2 *I want this line boldfaced;
>456 66,554 2 99,887 1
>
>I'd do it manually, but the report is 500 pages long.
>
>TIA,
>
>Pat Moore
|