topic Format a row in proc report using excelxp in ODS and Base Reporting

Format a row in proc report using excelxp

Reeza — Tue, 26 Jul 2011 00:11:23 GMT

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 — Tue, 26 Jul 2011 17:38:06 GMT

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 — Tue, 26 Jul 2011 19:05:51 GMT

Thanks, the paper had the examples I needed!