BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sjughent
Obsidian | Level 7

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;

 

1 ACCEPTED SOLUTION
4 REPLIES 4
Cynthia_sas
SAS Super FREQ
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
sjughent
Obsidian | Level 7

Thanks fot your answer.

 

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

ballardw
Super User

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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