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!
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
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
Thanks, the paper had the examples I needed!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.