topic Re: Change color of rows in Report Output in SAS EG7.1 in SAS Enterprise Guide

Change color of rows in Report Output in SAS EG7.1

VarunD — Fri, 02 Mar 2018 16:11:54 GMT

Hi,

Is there an option in EG to change the colors of specific observations (rows). I see that I could go to edit and table properties and then choose different background colors for alternate rows but this is not what I am trying to achieve. The rows are inconsistent.

Varun

Re: Change color of rows in Report Output in SAS EG7.1

TomKari — Fri, 02 Mar 2018 16:50:47 GMT

If you're using "List Report Wizard", which uses PROC REPORT as the underlying code, it's definitely possible by modifying the SAS code.

I've played around with the wizard a bit, and I don't think you can do it from the wizard. Are you comfortable copying and modifying SAS code?

Tom

Re: Change color of rows in Report Output in SAS EG7.1

VarunD — Fri, 02 Mar 2018 16:55:02 GMT

Yes I can work with code too.
Thanks Tom.

Re: Change color of rows in Report Output in SAS EG7.1

TomKari — Fri, 02 Mar 2018 16:59:12 GMT

In that case, this should get you a good distance to where you want to go.

http://support.sas.com/kb/23/353.html

Re: Change color of rows in Report Output in SAS EG7.1

VarunD — Fri, 02 Mar 2018 19:02:56 GMT

Thanks a lot !