The SAS Output Delivery System and reporting techniques

Convert Microsoft Color into SAS

Reply
Occasional Contributor
Posts: 17

Convert Microsoft Color into SAS

Hello,

 

I'm wondering if there is an easy way to convert a color I see in - say Word - into SAS - so when I create an RTF document, the color is the same or close to it.  For example, I've been requested to mirror a document that's already created.  When I hover over one of the cells in this pre-existing document - the fill color appears to be aqua - Accent 5 - Lighter 80%.  When I go into SAS and indicate the color to be aqua - it's like Carolina Panther aqua, and I'm not sure how to tweak it to be a closer shade.  This is my code...

 

proc template;

define style styles.newrtf;

parent=styles.RTF;

replace color_list /

'bgH'= aqua;

end;

run;

 

OPTIONS NODATE;

ODS LISTING CLOSE;

 

ods escapechar="#";

ods rtf body="&DIR.\DOC\JH Q&QTR._20&EFFYR. Automated Non Medical Agenda.rtf" style=newrtf;

 

proc PRINT data=HA&QTR NOOBS;

run;

 

ods rtf close;

 

ODS LISTING;

 

Any direction is appreciated!


Chip

 

Super User
Super User
Posts: 9,813

Re: Convert Microsoft Color into SAS

You need to get the RGB numbers from the cell:

https://wordribbon.tips.net/T000261_Discovering_the_RGB_Value_of_a_Custom_Text_Color.html

 

Then you can take these numbers and convert it to a hex value:

http://www.yellowpipe.com/yis/tools/hex-to-rgb/color-converter.php

 

Then use this hex value in your template.  Is it really worth it though, I mean blue is blue, if its a fraction of a shade less or more makes no odds.  Its sounds like making work for the sake of it.

Occasional Contributor
Posts: 17

Re: Convert Microsoft Color into SAS

Welp - the converter thing didn't really work for me (result looked white to me) but I did notice at the bottom of the last link you referenced a bunch of color examples at the bottom of the page.  I just used one of those.  Thanks!

Super User
Posts: 10,534

Re: Convert Microsoft Color into SAS

I once used a utility that would tell you the RGB value of pixels in pictures. Used it on screenshots taken with IrfanView to find the exact value of our CD-compliant web background.

Google might find it or a similar one.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Posts: 8,214

Re: Convert Microsoft Color into SAS

When I need to identify a color I usually use the paint program that comes with Windows. I copy and paste the picture or document into paint and then use the dropper icon to add the color to paint's palate. In the palate, the three color settings are there for the desired color.

 

Art, CEO, AnalystFinder.com

 

Ask a Question
Discussion stats
  • 4 replies
  • 144 views
  • 1 like
  • 4 in conversation