data WORK.TEST;
infile datalines delimiter=',';
input regionsnummer:12. teststed:$84. dato:date9. analysebeskrivelse:$564.
ventetid:12. ledigtid:$4.;
format dato ddmmyyd8.;
datalines4;
1801,TescenterX,01DEC2020, Nære kontakter, 0.6, >10%
1802, TestcenterY, 01DEC2020, Nære kontakter,0.01 ,<10%
1803, TestcenterZ, 02DEC2020, Åbne testtilbud, 0.02,<10%
1801, TestcenterW, 03DEC2020,Åbne testtilbud ,0.7 ,>10%
1802, TestcenterYN, 04DEC2020,Åbne testtilbud,0.3 ,>10%
1802, TestcenterYX,05DEC2020,Nære kontakter,0.0006 ,<10%
1804, TestcenterYB, 01DEC2020, Åbne testtilbud,0.004 ,<10%
1803, TestcenterYV,02DEC2020, Åbne testtilbud, 0.002,<10%
;;;;
options mprint;
proc format;
value pctf .=' ' low-<0.1='<10%' 0.1-high='>10%';
value colorf .=white low-<0.1=lightmoderatered 0.1-high=lightmoderategreen;
run;
%macro many_col;
proc sql noprint;
select count(distinct dato) into :ncols from test;
quit;
%put &=ncols;
proc report data=test;
columns regionsnummer teststed dato,ventetid;
define regionsnummer/group;
define teststed/group;
define dato/across;
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 Is it possible to devide this report further, so in my excel ouput I will have several sheets based on region. So each sheet will only be one region?
... View more