The SAS Output Delivery System and reporting techniques

proc report ods pdf, cover page and insert file

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 17
Accepted Solution

proc report ods pdf, cover page and insert file

[ Edited ]

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;

 


Accepted Solutions
Solution
‎02-12-2018 03:25 AM
Occasional Contributor
Posts: 17

Re: proc report ods pdf, cover page and insert file


All Replies
SAS Super FREQ
Posts: 9,310

Re: proc report ods pdf, title page and insert file

Hi:
I am fairly sure there have been other Forum postings on how to put a logo into a title for ODS PDF. I also thought that there were some Tech Support notes on the topic. Have you searched the Community Forum for previous postings? I did a quick search on support.sas.com and found this http://support.sas.com/kb/36/707.html which shows how to 1) put a logo in a title statement and 2) how to make the logo clickable. If you do NOT want to make the logo clickable, you would leave off the URL= option in the code on the Full Code tab.
cynthia
Occasional Contributor
Posts: 17

Re: proc report ods pdf, title page and insert file

Posted in reply to Cynthia_sas

Thanks fot your answer.

 

Can I create the cover page, or put the tekst page between two tebles that created with proc report?

Super User
Posts: 13,283

Re: proc report ods pdf, title page and insert file

Title text could be accomplished with either ODS TEXT or PROC ODSTEXT followed by an ODS PDF Startpage=NOW ; to insert a page break.

Solution
‎02-12-2018 03:25 AM
Occasional Contributor
Posts: 17

Re: proc report ods pdf, cover page and insert file

I've got the solution from hier https://support.sas.com/resources/papers/proceedings09/043-2009.pdf

Thanks a lot.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 238 views
  • 0 likes
  • 3 in conversation