BookmarkSubscribeRSS Feed
gzr2mz39
Quartz | Level 8

Excel has an option to add "data bars" (under Conditional Formatting) to tables.
Does anyone know how to add "data bars" to a proc report "analysis" variable?
I'm using tagsets.excelxp to output my proc report tables.

proc report data=month_tots1 nowd contents="Claims" out=test
style(header)=[font_weight=bold background=CX90D9D7];
options missing='';
column mdoi ydoi, (osha_tot);
define mdoi / group "Month" format=mof. order=data style(column)={just=l};
define ydoi / across "" format=ydoif. order=data;
define osha_tot / analysis 'Total';
run;

Thank you.

3 REPLIES 3
Cynthia_sas
SAS Super FREQ

Hi:

  This is probably a question for Tech Support. TAGSETS.EXCELXP generates Spreadsheet Markup Language that is specific to Office 2003. You would have to find out 1) whether there is an XML specification in the Office 2003 XML for the data bars and IF there is an XML specification in the Office 2003 XML for the data bars, then, 2) whether there is a way to send the XML instruction to TAGSETS.EXCELXP.

  If I take SAS out of the picture and go into  Excel, and  put data bars into a worksheet and then save the file as an Excel XML file, I get a message that says the conditional formatting cannot be saved to the XML file. This leads me to believe that you cannot directly insert data bars into your PROC REPORT output. However, it might be possible to simulate the data bars with a color background or using a font (like Bissantz Spark Fonts).

  For example, if you review this paper, you can see how one person implemented sparkline type of report:

http://www.lexjansen.com/pnwsug/2007/Paul%20OdenKamp%20-%20Producing%20Sparkline%20graphs%20with%20S...

  That's why I'd recommend working with Tech Support -- they can help you figure out whether what you want to do can be done with TAGSETS.EXCELXP.

cynthia

Ch_ndra
Calcite | Level 5

Hi,Can someone answer this question please.....

RW9
Diamond | Level 26 RW9
Diamond | Level 26

Hi,

This question is 4 years old.  Please start a new question thread with examples of what you want.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1156 views
  • 1 like
  • 4 in conversation