Hi,
I would like create a report that contains a table, from the code (is OK) and the cover page before the table that has some text and logo from jpg fle. Is that possible? I have no solution for title page and inserted file.
Thanks a lot,
Svetlana
proc format;
value aantal low-<100='GRAYC0';
value heroproep low-<1='VLIGB' 1-<3='VLIYG' 3-high='orange';
value kwaliteit low-<85='orange' 85-high='VLIGB';
value eersteverw 0-<5='VLIGB' 5-<7='VLIYG' 7-high='orange';
value vervolgverw 0-<3='VLIGB' 3-<5='VLIYG' 5-high='orange';
value aanlevertijd 0-<90='orange' 90-high='VLIGB';
value vorigeMX 0-<90='orange' 90-high='VLIGB';
run;
%let FolderForPDF = %str(X:\XXX\XXX_rapporten);
ods escapechar='^';
options missing='0' orientation=landscape nodate leftmargin=1.0in rightmargin=1.0in ;
ods listing close;
ods pdf file="&FolderForPDF.\&riziv1 .pdf." notoc;
proc report data=data.technische_recall_L1_&periode nowd spanrows
style(header)=[background=LIPK] STYLE(Header)=[FONT_FACE=Times] STYLE(column)=[FONT_FACE=Times] ;
compute totaal_Aant&periode;
if totaal_Aant&periode<100 then call define(_row_,'style','style=[background=white]');
endcomp;
title f='Times' italic j=c h=18pt 'ME feedback eerste lezer 2010-2017';
title3 '^{newline 1}'; /* one extra line */
title4 j=c f='Times' italic h=18pt "Technische heroproep 2010-2017";
title5 '^{newline 2}'; /* insert extra spaces */
title6 j=l f='Times' h=14pt italic "Tabel 1. Technische heroproep eerste lezer 2010-2017";
column ('Jaar van de screening' year )
('1ste lezer' RIZIV_1ste_LEZER NameL1)
('Totaal/aantal MX' totaal_Aant&periode)
('Technisch niet/interpreteerbaar' Aant_tni&periode Pct_tni&periode);
define year / center 'Jaar' ;
define RIZIV_1ste_LEZER / center 'RIZIV' ;
define NameL1 / 'Naam' ;
define totaal_Aant&periode / center 'N' ;
define Aant_tni&periode / center 'N' ;
define Pct_tni&periode / center '%' style(column)=[background=heroproep.];
run;
ods pdf text="^1n";
ods pdf text="^S={font=('Times New Roman',10pt)}De technische heroproepproportie staat voor het percentage 'technisch niet interpreteerbare' mammografieën.";
ods pdf text="^1n";
ods pdf text="^S={font=('Times New Roman',10pt)}De Europese richlijnen stellen de volgende norm:";
ods pdf text="^S={font=('Times New Roman',10pt) background=VLIYG}- aanvaardbaar: maximaal 3% van de mammografieën met technische heroproep";
ods pdf text="^S={font=('Times New Roman',10pt) background=VLIGB}- wenselijk: minder dan 1% van de mammografieën met technische heroproep.";
ods pdf text="^1n";
ods pdf text="^S={font=('Times New Roman',10pt)}In bovenstaande tabel wordt de technische heroproepproportie per mammografische eenheid weergegeven, onderverdeeld per 1ste lezer.";
ods pdf text="^1n";
ods pdf text="^S={font=('Times New Roman',10pt) background=GRAYC0} Als de 1ste lezer minder dan 100 dossiers beoordeeld heeft, zijn de resultaten enkel indicatief (in grijs).";
options orientation=landscape nodate nolabel;
ods pdf;
run;
ods pdf close;
title;
I've got the solution from hier https://support.sas.com/resources/papers/proceedings09/043-2009.pdf
Thanks a lot.
Thanks fot your answer.
Can I create the cover page, or put the tekst page between two tebles that created with proc report?
Title text could be accomplished with either ODS TEXT or PROC ODSTEXT followed by an ODS PDF Startpage=NOW ; to insert a page break.
I've got the solution from hier https://support.sas.com/resources/papers/proceedings09/043-2009.pdf
Thanks a lot.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.