Hello, I have a pretty simple report where I put an X on the buildings that are missing. The x is a format and the variable ind_manq is really a 1 or a 0 (missing building). I also want it to be red when there's an X but I can't seem to get the coulour working. My data set is just a list of buildings, the fiscal period we're in and the ind_manq variable. /*Exportation EXCEL*/
OPTIONS NODATE NONUMBER MISSING=" " orientation=landscape papersize=LEGAL;
ods excel file="Directory\.xlsx"
options(suppress_bylines="yes"
sheet_name="Sheet"
embedded_titles="yes"
embedded_footnotes="yes"
frozen_headers="yes");
PROC REPORT DATA= mylib.mydata nowd split="|" spanrows STYLE(HEADER)=angle_header;
options missing="";
COLUMN nomRegion nomEtabl n=cntage ind_manq2 ind_manq;
DEFINE nomRegion / group "Region" STYLE(column)={JUST=L cellwidth=2.0in};
DEFINE nomEtabl / order "Établissement" STYLE(column)={JUST=L cellwidth=2.0in};
DEFINE cntage / noprint;
DEFINE ind_manq2 / noprint;
DEFINE ind_manq / "&PER_V." STYLE(column)={JUST=R cellwidth=1.0in} format=ixs.;
compute ind_manq;
if ind_manq=0 then call define (_COL_, "style", "style=[background=red]");
endcomp;
rbreak after /summarize;
compute after;
ind_manq = "Total remplis";
endcomp;
title "Title";
title2 "Extraction effectuée en date du &date.";
footnote bold height=16pt COLOR=red J=C "DOCUMENT DE TRAVAIL";
run; Here's an image of my table The cell with the x should be red Thank you for your consideration.
... View more