topic Re: Proc report-underline or highlight every 2nd row in SAS Procedures

Proc report-underline or highlight every 2nd row

Steelers_In_DC — Fri, 25 Oct 2013 15:42:17 GMT

Hello,

I have an output that I would like to seperate every 2nd row. Either with an underline or highlighting. I'm not married to proc report either. If there is another procedure where it is easier I'm glad to use it. I've attached the output, hopefully that will help you understand what I'm trying to do.

Thanks in advance,

Mark

Re: Proc report-underline or highlight every 2nd row

Reeza — Fri, 25 Oct 2013 15:50:00 GMT

Its called "Banding"

http://support.sas.com/resources/papers/proceedings13/366-2013.pdf

Last example in this paper explains how to do it in Proc Tabulate.

Re: Proc report-underline or highlight every 2nd row

Steelers_In_DC — Fri, 25 Oct 2013 16:11:32 GMT

Is there a way to do this for a large dataset without listing the variable name in a proc format? I tried to use the mod function even/odd but that isn't working.

Re: Proc report-underline or highlight every 2nd row

Reeza — Fri, 25 Oct 2013 16:17:27 GMT

http://www2.sas.com/proceedings/sugi26/p003-26.pdf

Example 7 here instead.

Re: Proc report-underline or highlight every 2nd row

data_null__ — Fri, 25 Oct 2013 16:25:12 GMT

This example from a few days ago should help.

https://communities.sas.com/message/182966#182966