topic Re: Adding images into ods pdf one below the other with space in ODS and Base Reporting

Adding images into ods pdf one below the other with space

sanjay1 — Thu, 25 Aug 2016 14:19:26 GMT

Hi SAS experts

I want add two images one below the other with some space in cover page, and want to add a page title for all the pages in the middle of the page...is there is any way to do this..waiting for your help.

With the below code I got two images one below other but without any space. waiting for your help.

data _pdftitle;
holder=1;
text="New map for the country wide
accounts";
run;

ods escapechar = '^';
title height=20pt;
title1 height=25pt;

ods pdf file="C:\users\kalalsan\desktop\logo_test_maps.pdf" notoc startpage=no color=full;
ods pdf text = '^{style [preimage="C:\Users\name\Desktop\new1.jpg"}';
ods pdf text = '^{style [preimage="C:\Users\name\Desktop\new2.jpg"}';

title;
title1 ;
footnote1;
footnote2;

Re: Adding images into ods pdf one below the other with space

Ksharp — Thu, 25 Aug 2016 14:32:36 GMT

Not Sure:


ods pdf text = '^{style [preimage="C:\Users\name\Desktop\new1.jpg"}  ^n^n^n^n  ^2n    ';
ods pdf text = '^{style  [preimage="C:\Users\name\Desktop\new2.jpg"}';

Re: Adding images into ods pdf one below the other with space

sanjay1 — Fri, 26 Aug 2016 08:40:18 GMT

Its working...

Thank you

Re: Adding images into ods pdf one below the other with space

sanjay1 — Fri, 26 Aug 2016 10:02:36 GMT

Is there is any way to increase the font size of ods pdf text without creating any style template.

Re: Adding images into ods pdf one below the other with space

Ksharp — Fri, 26 Aug 2016 10:10:49 GMT

You can use style FONT_SIZE:



ods escapechar='~';
ods text='~S={fontsize=20} xxxxxxxxxxxxx';
proc print data=sashelp.class;run;

Re: Adding images into ods pdf one below the other with space

sanjay1 — Mon, 29 Aug 2016 14:09:26 GMT

Thanks for your help..

Re: Adding images into ods pdf one below the other with space

sanjay1 — Tue, 06 Sep 2016 10:22:55 GMT

Hi Ksharp,

Could you please help me in this..

I want to calculate the % change for fy13-fy16/fy13
But since I have missing values am getting the result as missing.

Here is the code

data sample;
input fy13 fy14 fy15 fy16;
datalines;
. 15 . 16
19 . 2 15
. 22 8 .
17 18 18 20
24 28 . 9
;
run;

below is my code, but with this code am getting zero obasrvations.

data test;

set sample;

if fy13=. then delete;

if fy14=. then delete;

if fy15=. then delete;

if fy16=. then delete;

run;

Re: Adding images into ods pdf one below the other with space

Ksharp — Wed, 07 Sep 2016 00:58:18 GMT

Add a condition before it :

if not missing(fy13) and not missing(fy16) then x=(fy13-fy16)/fy13;

Re: Adding images into ods pdf one below the other with space

sanjay1 — Wed, 07 Sep 2016 08:40:44 GMT

Thank you very much that works cool.

Re: Adding images into ods pdf one below the other with space

sanjay1 — Tue, 13 Sep 2016 10:50:22 GMT

Hi Ksharp,

I am adding the word document as a cover page in ods pdf file.

I have converted the word to pdf and used in my progrm. But am getting the error. Please help me

Below is the error:

Error: Unable to load image C:\temp\test.pdf; default image will be used instead

Following is my code

ods pdf file='path.pdf' notoc startpage=no color=full style=colorramp;

ods pdf text='^{style[preimage="C:\temp\test.pdf"}';

ods pdf startpage=now;

goptions hsize=3.99 in vsize=4.2 in;
proc print data=sashelp.class;

goptions horigin=0 in vorigin=4 in;

run;

proc means data=sashelp.class;

goptions horigin=4.25;

var height;
run;

ods pdf close;

Re: Adding images into ods pdf one below the other with space

Ksharp — Wed, 14 Sep 2016 01:48:05 GMT

It is PDF file ( C:\temp\test.pdf ). Not Image file ( C:\temp\test.png ) . You can not use PDF in that way.

Re: Adding images into ods pdf one below the other with space

sanjay1 — Wed, 14 Sep 2016 12:22:39 GMT

Thank you that helps me.

Re: Adding images into ods pdf one below the other with space

sanjay1 — Wed, 14 Sep 2016 16:06:41 GMT

Hi Ksharp,

Is there is any way to add contents in the cover page of ods pdf.

The attched is the format, Please guide

Re: Adding images into ods pdf one below the other with space

Ksharp — Thu, 15 Sep 2016 02:28:56 GMT

Sorry. I am going to leave it to @Cynthia .
Maybe you could get it by creating a RTF file and convert it into a PDF file.