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
I found the below link, thought would be helpful to you.
http://support.sas.com/kb/23/353.html
Thanks,
Jagadish
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.
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
It really worked, still trying to get the Multiple observation into one row... having difficult times... any advise would be appreciated.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.