Hi Cynthia.   Thanks for all your insight. This is my final code I think and I'm quite pleased with it now. I created some alias variables to sort the table properly.  The variabel  Sorterings_var, is 1 for error logs, 2 for logs>50 Mb and 3 for logs with no errors because that's how I would like the variable "Fejl" to be sortet. Depending on if there are any errors in the logs the macro %keep will kick in and include specific variables which will no be present if there are no errors at all in any logs.   See screenshots of the table in outlook to see how it looks like.   I have included the code below.   Is there anything else I can optimize or code that doesn't make sense because it's ods html?           filename mail email to = (&program_ansvarlig_mail) /*Til test*/ /* to = (&program_to_mail) cc = (&program_cc_mail) */ bcc = ("") subject = "&emnetekst." from = &program_ansvarlig_mail importance = &mail_vigtighed. content_type = "text/html"; ods _all_ close; ods html body=mail; options nodate missing=""; title1 justify=left height=14 "<i> <b> Oversigt over logs </b> </i>"; title2 " "; footnote1 justify=left height=8 "<a href='file:///&logfilmappe'>Link til mappen med alle logfiler.</a>"; proc report data=samlet_logs_mail_4 /*spanrows*/ nowd nowindows nocenter split='\' style(report) =[fontsize=12 borderwidth=1 bordercolor=black vjust=b] style(header) =[fontsize=12 background=dagray color=white fontweight=bold vjust=b] style(column) =[fontsize=12 ] style(summary)=[fontsize=14 fontweight=bold vjust=b textalign=r] style(lines) =[fontsize=14 fontstyle=italic fontweight=bold ]; col ("Oversigt over kørsler" Sorterings_var Fejl Startdato=Startdato_sort Starttid=Starttid_sort Lognavn Link Startdato Starttid Slutdato Sluttid Kørselstid Filstr_Mb Antal_programmer &keep_var) ; /*----- Sorteringsvariable, som ikke vises i output ------*/ define Sorterings_var / order order=internal noprint; define Startdato_sort / order order=internal noprint; define Starttid_sort / order order=internal noprint; Define Fejl / group "Status" style(header)=[borderwidth=0.1]; compute Fejl / char; if Fejl in("Fejl i log") then call define(_col_,'style','style=[background=STPK]'); if Fejl in("Log > 50 Mb") then call define(_col_,'style','style=[background=LIPK]'); if Fejl in("Ingen fejl i log") then call define(_col_,'style','style=[background=BILG]'); endcomp; define Lognavn / group "Lognavn" style(header)={just=center vjust=b} width=200 ; define link / group "Link til log" width=200 ; define Startdato / group "Start dato" style(header)={just=center vjust=b} width=25 ; define Starttid / group "Start tid" style(header)={just=center vjust=b} width=25 ; define Slutdato / group "**bleep** dato" style(header)={just=center vjust=b} width=25 ; define Sluttid / group "**bleep** tid" style(header)={just=center vjust=b} width=25 ; define Kørselstid / group "Kørselstid" style(header)={just=center vjust=b} width=25 ; define Filstr_Mb / group "Filstr., Mb" style(header)={just=center vjust=b} width=25 ; define Antal_programmer / "# programmer" style(header)={just=center vjust=b} width=15 ; %macro keep; %if &Antal_fejl>0 %then %do; define Programnavn / "Fejl-program" style(header)={just=center vjust=b} width=25 ; define Fejltype / "Fejltype" style(header)={just=center vjust=b} width=25 ; %end; %mend keep; %keep; rbreak after / summarize skip; %macro keep; %if &Antal_fejl>0 %then %do; compute after; line "Der er samlet" antal_fejl.sum commax14.0 " fejl i alle logs."; endcomp; break after Fejl /; compute after Fejl / style={color=ltgray background=ltgray fontsize=.1pt cellheight=.1pt}; line ""; endcomp; %end; %mend keep; %keep; run; ods html close; ods _all_ close;     ... View more

Hi Cynthia Thanks for the two replies. I did post data on my first post. I tried the solution above, with a computed variable. One thing I couldn't solve was to group the computed variable. I could do that in my own solution. If you see the screenshot of the report, if there are multiple lines pr. log/link etc. it should only show the link one time. ... View more

Hi again   I found a solution for the link alias with the following: data samlet_logs_mail_3 (drop=Link_old); set samlet_logs_mail_2 (rename=(Link=Link_old)); Link =catt('<a href="',substr(Link_old, 1, length(Link_old)-4),'.log">',"Link til log",'</a>'); output; run; Are there anyone who can answer me on my other two questions?:   If someone also can say why the variable that shows number of errors in the logs (“Antal fejl”) is all missing I would be glad. And is there some way to get the colored area in the first column, to be seen as "one cell" pr. error type, so there is no space between the different rows?    ... View more