Hi.
I have the following code for a proc report.
I have stated that I want some colors, but they do not show in the expected output.
Also I have shown the ouput below - I want to remove the row with the "ventetid" labels - is that possible?
%macro many_col;
proc sql noprint;
select distinct dato into :ncols from pdf1;
quit;
proc format;
value pctf .=' ' low-<0.1='<10%' 0.1-high='>10%';
value colorf .=white low-<0.1=lightmoderatered 0.1-high=Steel;
run;
proc report data=pdf1;
columns region teststed dato, ventetid;
define region/group;
define teststed/group;
define dato/across order=internal format= ddmmyyd10.;
define ventetid/sum format=pctf5.;
compute ventetid;
%do i=1 %to &ncols;
call define("_c%eval(&i+2)_",'style','style={background=colorf.}');
%end;
endcompute;
run;
%mend;
%many_col
Also is it possible in the proc report code to divide the variable "teststed" up in two other groups that will be based on the observations under "teststed" - so e.g. if "teststed" includes something with XXXX then put it in under a new label called "EXAMPLE" etc. So basically under each "region" i want two groups of variables with matching observations.
hope it makes sense 🙂