The SAS Output Delivery System and reporting techniques

Format a row in proc report using excelxp

Accepted Solution Solved
Reply
Super User
Posts: 17,912
Accepted Solution

Format a row in proc report using excelxp

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!


Accepted Solutions
Solution
‎07-26-2011 01:38 PM
SAS Super FREQ
Posts: 8,744

Format a row in proc report using excelxp

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

View solution in original post


All Replies
Solution
‎07-26-2011 01:38 PM
SAS Super FREQ
Posts: 8,744

Format a row in proc report using excelxp

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

Super User
Posts: 17,912

Format a row in proc report using excelxp

Thanks, the paper had the examples I needed!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 171 views
  • 0 likes
  • 2 in conversation