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    ... View more

Alsothe ouput shows me the "ventetid " label under the dates. Can i remove that? And why doesnt it color the fields? Also a question, as i am very new in SAS: Can I divide "tested" further i specific names, so that "teststed" will have to different categories:   %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 format=ddmmyy10.; 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   ... View more

I ran this code with my real dataset It works an looks good. But the colors do not show in the fields for ventetid 🙂 What did i do wrong here? %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 0-<0.1='Firebrick' 0.1-high='Steel'; run; proc report data=pdf1; columns region teststed dato,ventetid; define region/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 ... View more

Thank you for that. I had a variable called Analysebeskrivelse in the datalines. But I cannot see it in use in the proc report code? ... View more

There Will Always approximately be around 2 weeks of dates. I get new data everyday so there will always be new dates from the current date that I get the data. The output should give all combinations. There can be observations with same teststed but different values in other columns. Hope that can help. ... View more

Thank you!. It looks very good with the data I made for the example.  In my real data i have over 5000 observations. How can a macro be used in this case? I have no experience in SAS - so its hard for me to find this information ... View more

data WORK.TEST; infile datalines delimiter=','; input regionsnummer:12. teststed:$84. dato:date9. analysebeskrivelse:$564. ventetid:12. ledigtid:$4.; 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% ;;;; proc print; run; ... View more

data WORK.TEST; infile datalines dsd truncover; input regionsnummer:BEST12. teststed:$84. dato: DDMMYY10. analysebeskrivelse:$564. ventetid:BEST12. ledigtid:$4.; datalines4; 1801,Tescenter X,"12/01/2020", 0.6, ">10%" 1802, Testcenter Y, "12/02/2020", 0.01, "<10%" 1803, Testcenter Z "12/03/2020", 0.02, "<10%" 1801, Testcenter W "12/04/2020", 0.1, ">10%" 1802, Testcenter Y-N, "12/05/2020", 0.2, ">10%" 1802, Testcenter YX "12/13/2020", 0.01, "<10%" 1804, Testcenter YB, "12/15/2020", 0.01, "<10%" 1803, Testcenter Y,V "12/20/2020", 0.01, "<10%"; proc print; run; is that fine? ... View more

data WORK.TEST; infile datalines dsd truncover; input regionsnummer:BEST12. teststed:$84. dato: DDMMYY10. analysebeskrivelse:$564. ventetid:BEST12. ledigtid:$4.; datalines4; 1801,Tescenter X,"12/01/2020", 0.6, ">10%" 1802, Testcenter Y, "12/02/2020", 0.01, "<10%" 1803, Testcenter Z "12/03/2020", 0.02, "<10%" 1801, Testcenter W "12/04/2020", 0.1, ">10%" 1802, Testcenter Y-N, "12/05/2020", 0.2, ">10%" 1802, Testcenter YX "12/13/2020", 0.01, "<10%" 1804, Testcenter YB, "12/15/2020", 0.01, "<10%" 1803, Testcenter Y,V "12/20/2020", 0.01, "<10%"; proc print; run; is that fine? ... View more

Sorry I made the data lines wrong   data WORK.TEST; infile datalines dsd truncover; input regionsnummer:BEST12. teststed:$84. dato: DDMMYY10. analysebeskrivelse:$564. ventetid:BEST12. ledigtid:$4.; datalines4; 1801,Tescenter X,"12/1/2020", 0.6, ">10%"; proc print; run; ... View more

This i my data: proc import datafile = "F:\Grupper\DIAS\KID\devel\MMEA\SSI kapacitet Samfundsspor - 2020-12-15.csv" dbms=csv out= work.vente replace; delimiter = ";"; guessingrows=3000; run; proc sql; create table ventetider as select distinct regionsnummer, teststed, dato, analysebeskrivelse, sum(kapacitet)as kapacitet, sum(booket_kapacitet) as booket_kapacitet from ventetider group by dato, teststed, analysebeskrivelse order by dato, teststed; quit; then i make a new column to get the "ledigtid" data pdf1; set pdf1; ventetid = (kapacitet - booket_kapacitet)/kapacitet; if ventetid >= 0.1 then farve = 1; if ventetid < 0.1 then farve = 2; if ventetid = . then farve = 3; if ventetid >= 0.1 then Ledigtid = ">10%"; if ventetid < 0.1 then Ledigtid = "<10%"; run; proc sort data= pdf1; by dato; run; my data is big but here is some data lines, just one line: data WORK.TEST; infile datalines dsd truncover; input Make:BEST12. regionsnummer:$84. teststed:DDMMYY10.. dato:$564. analysebeskrivelse:BEST12. ventetid:$4. ledigtid; datalines4; 1801,Tescenter X,"12/1/2020", 0.6, ">10%"; proc print; run; ... View more

Thank you so much it worked!   Do you know if you can add to you code, that you before running the PDF you want to remove some of the columns? proc report data=pdf1 nowd; column teststed analysebeskrivelse dato Ledigtid Nærekontakter åbnetesttilbud; define teststed/display; define Ledigtid/ display; define Nærekontakter/computed; define åbnetesttilbud/computed; 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; compute Nærekontakter/character; if find(teststed,'Nære kontakter')>0 or find(analysebeskrivelse,'Nære kontakter')>0 then do; Nærekontakter=ledigtid; if Ledigtid = ">10%" then call define(_col_,"style","style={background=green}"); if Ledigtid = "<10%" then call define(_col_,"style","style={background=red}"); end; endcomp; compute åbnetesttilbud/character; if find(analysebeskrivelse,'Virustest')>0 then do; åbnetesttilbud=ledigtid; if Ledigtid = ">10%" then call define(_col_,"style","style={background=green}"); if Ledigtid = "<10%" then call define(_col_,"style","style={background=red}"); end; endcomp; run; I use ledigtid and analysebeskrivelse in my statements, but I dont want them in my final report. Can I remove them? ... View more

ods pdf notoc file="F:\Brugere\MMEA\hey1.pdf" ; proc report data=pdf1 nowd; column teststed analysebeskrivelse dato Ledigtid Nærekontakter åbnetesttilbud; define teststed/display; define Ledigtid/ display; define Nærekontakter/computed; define åbnetesttilbud/computed; 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; compute Nærekontakter; if find(teststed,'Nære kontakter')>0 or find(analysebeskrivelse,'Nære kontakter')>0 then do; Nærekontakter=ledigtid; if Ledigtid = ">10%" then call define(_col_,"style","style={background=green}"); if Ledigtid = "<10%" then call define(_col_,"style","style={background=red}"); end; endcomp; compute åbnetesttilbud; if find(analysebeskrivelse,'Virustest')>0 then do; åbnetesttilbud=ledigtid; if Ledigtid = ">10%" then call define(_col_,"style","style={background=green}"); if Ledigtid = "<10%" then call define(_col_,"style","style={background=red}"); end; endcomp; run; ods pdf close; I added the XX (called nære kontakter) and YY (åbne testetilbud) I now get two new columns with the matching color basedon ledigtid, but i still want the text "<10%" etc in the new columns ... View more