BookmarkSubscribeRSS Feed
sathishthangamani
Calcite | Level 5

Hello,

I am preparing a PROC Format and creating colors based on the values on that particular value.

Please let me know how to compare different variable and assign the colour to a variable.

PROC FORMAT;

     VALUE MY_SCRATVOl

           00001 - 00250 = RED

           00251 - 10000 = YELLOW

           10001 -  HIGH = WHITE

RUN;

PROC PRINT    DATA=POOLCNT_VCL SPLIT='*' NOOBS LABEL                

      STYLE(HEADER OBSHEADER)  = {BACKGROUNDCOLOR=GREY COLOR=WHITE   

                                  FONTWEIGHT=BOLD TEXTALIGN=CENTER } 

      STYLE(OBS DATA) = {BACKGROUNDCOLOR=WHITE COLOR=BLACK           

                                           TEXTALIGN=CENTER }        ;

      ID  COMPLIB LPAR

      VAR SCRATVOL / STYLE={FONT_WEIGHT=BOLD BACKGROUND=MY_SCRATVOL} ;

Thanks,

Sathish

6 REPLIES 6
Jagadishkatam
Amethyst | Level 16

I found the below link, thought would be helpful to you.

http://support.sas.com/kb/23/353.html

Thanks,

Jagadish

Thanks,
Jag
ballardw
Super User

It may be as simple as missing the period at the end of the MY_SCRATVOL format, should read MY_SCRATVOL. otherwise SAS is looking for a known specific color with that name and most likely not finding it.

sathishthangamani
Calcite | Level 5

Thanks for you responses. Yes the period at the end will fix this.

I will brief a bit...

I have two variables SCRATVOl & SCRATTHR.

I want to color SCRATVOL variable by comparing against SCRATTHR and mark the color in RED, YELLOW, WHITE for SCRATVOL.

Please let me know if ity is possible.

Thanks, Sathish

Reeza
Super User

You can but you do need proc report I think. Just change the condition in the calculate column as per the example linked to in post above.

sathishthangamani
Calcite | Level 5

It really worked, still trying to get the Multiple observation into one row... having difficult times... any advise would be appreciated.

ballardw
Super User

Time to show what you want the output to look like. "Multiple observation into one row" is not intuitively obvious what the desired output may be.

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!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 6 replies
  • 2592 views
  • 0 likes
  • 4 in conversation