Hi. with this code I made a proc report: ods pdf notoc file="F:\Brugere\MMEA\hej.pdf" ;
proc report data=pdf1 nowd;
column teststed analysebeskrivelse dato Ledigtid;
define teststed/display;
define Ledigtid/ display;
compute Ledigtid;
if Ledigtid = ">10%" then call define(_col_,"style","style={background=green}");
if Ledigtid = "<10%" then call define(_col_,"style","style={background=red}");
endcomp;
run;
ods pdf close;
This code gives me this report (I have just cut out a small piece): Is there a way to make new columns called fx "XX" and "YY". Column "XX" should contain all the values and colors of "Ledigtid" for those in "analysebeskrivelse" or "Teststed" who has the characters 'Nære kontakter' in the name. Anything else should be in "YY". So i want the colors green and red match with the new columns I want to make based on the names from Teststed. Does it make sense? I hope so 🙂
... View more