The SAS Output Delivery System and reporting techniques

Style using a cell pattern

Reply
Frequent Contributor
Posts: 83

Style using a cell pattern

I have the following code:

ods pdf file=_WEBOUT

proc report data=WORK.QUERY_FOR_APPEND_TABLE_009E_0000 nowd;

column cc unit SUM_of_schd_hrs elect_hrs mech_hrs single_day_delay

mtd_delay_perct goal MTBF MTTR;

compute single_day_delay;

if cc='506' AND single_day_delay <=7.1

then

call define ('single_day_delay', 'style', 'style=[background=green]') ;

endcomp;

Instead of using a color like green in the above code, I would like to create a pattern in the background.  For example, stripes or dots.  Reason being, not everyone has access to a color copier and I wanted the user to be able to identify cells with a pattern if printed B&W.

Any help with this would be appreciated.

SAS Super FREQ
Posts: 8,819

Re: Style using a cell pattern


Hi, cells only have a background color and foreground color, but you can specify shades of gray as the background(cxeeeeee - very light light gray; cxcccccc - a little darker; cxaaaaaa - a little darker; cx666666 a little darker or specify as GRAYEE, GRAYCC, GRAY66, etc), which should print on a grayscale printer. I think the only way to get a "pattern" in a cell would be to put an image of the pattern you want in the cell. The issue with that, is that you only have the possibility of PREIMAGE or POSTIMAGE to place the image, which means that the cell text would be to the right or left of the "pattern" image. You might try checking out the ODS report writing interface to see whether the DATA step syntax for writing custom reports allows cell text to be imposed over an image. That would be a question for Tech Support.

  I would be tempted in PDF to use textdecoration=overline or textdecoration=underline as a style override, because if you only had 2 possibilities, the overline could represent one condition and the underline could represent another condition.

cynthia

Frequent Contributor
Posts: 83

Re: Style using a cell pattern

Thank you Cynthia.  I used the three shades of gray because I have 3 conditions.  This will work.

Ask a Question
Discussion stats
  • 2 replies
  • 348 views
  • 0 likes
  • 2 in conversation