Format a row in proc report using excelxp

[Reeza]

Can't seem to find an example that similar to what I need, or blanking because its the end of the day...

I have a dataset that I'm outputting to excel with ods excelxp via proc report but one line is actually percentages.

I'm trying to format this row red and have the values show up as percentages.

I think i need to be using a tagattr but having a hard time figuring out how/where to specificy for a row specific format.

Any pointers appreciated.

Thanks!

[Cynthia_sas · Accepted solution]

Hi:

  You probably need to use your TAGATTR override in a CALL DEFINE statement. Something like this (untested):

compute pctvar;

  CALL DEFINE(_ROW_,'style','style={foreground=red tagattr="?????????"}');

endcomp;

I have some examples in my SGF paper:

http://support.sas.com/resources/papers/proceedings11/266-2011.pdf (look on page 20, where the entire row is made purple for grade=2)

cynthia

[Reeza]

Thanks, the paper had the examples I needed!