How do iI set a cell background pattern in PROC REPORT

eshupp — Thu, 27 Jan 2022 22:57:31 GMT

I am using CALL DEFINE in a PROC REPORT COMPUTE block to set cell background colors based on data values along with FLYOVER text. In some cases I would also like to change the pattern from solid to cross hatch to call out a unique situation with the same color category. Is there another STYLE attribute that controls the cell background pattern in addition to the color?

Re: How do iI set a cell background pattern in PROC REPORT

ballardw — Fri, 28 Jan 2022 00:51:36 GMT

You should probably reference which ODS destination you are sending the result to. There may be options available for one destination that do not work for others.

Better might be to also show the current Proc Report code as well as the ODS destination code. That might allow a response that does not rely on different data structure than you currently have or uses some option that breaks something else in your report tables.

Best would be include some example data in the form of a data step so some one can test suggestions without having to make a bunch of stuff up. If you are using custom formats the code for the formats should be included. If you are using any macro variables include assignment statements to set a reasonable value.

topic How do iI set a cell background pattern in PROC REPORT in SAS Programming

How do iI set a cell background pattern in PROC REPORT

Re: How do iI set a cell background pattern in PROC REPORT