Hello All, I have a small sample dataset, which has three variables, ID, Grade and Result. I want to report this dataset using PROC Report and assign the different colors to Grade based on the value of variable Result. Let's say, if Result is Pass then the background color of Grade is green; otherwise, it would be in red. At the same time, I only want to see ID and Grade in the output, so I use NOPRINT for Result. Here is my code: DATA WORK.Test; INFILE DATALINES; INPUT ID Grade Result $; DATALINES; 1 90 Pass 2 65 Pass 3 57 Fail ; RUN; PROC REPORT DATA=WORK.Test STYLE(REPORT) = {OUTPUTWIDTH=60%} STYLE(HEADER) = [JUST = CENTER FONT_FACE = calibri FONT_SIZE = 3 FOREGROUND = Black BACKGROUND = Orange PROTECTSPECIALCHARS=OFF]; COLUMN ID Grade Result; DEFINE ID / DISPLAY STYLE(COLUMN)=[JUST=l FONT_FACE = calibri FONT_SIZE = 3]; DEFINE Grade / DISPLAY STYLE(COLUMN)=[JUST=l FONT_FACE = calibri FONT_SIZE = 3]; DEFINE Result / NOPRINT STYLE(COLUMN)=[JUST=l FONT_FACE = calibri FONT_SIZE = 3]; COMPUTE Grade; IF Result = 'Pass' THEN CALL DEFINE("_COL_", "STYLE", "STYLE={BACKGROUND=CX00FF00}"); IF Result = 'Fail' THEN CALL DEFINE("_COL_", "STYLE", "STYLE={BACKGROUND=CXFF0000}"); ENDCOMP; QUIT; The output I want is Could someone kindly help me figure out how to do it? Thanks in advance!
... View more