topic Re: RTF in multiple pages in Graphics Programming

RTF in multiple pages

SJN — Thu, 29 Sep 2016 06:20:35 GMT

Hi All,

I have 10 customers. I want to display each customer transaction in single page RTF. How to achive that. could you help me.

Re: RTF in multiple pages

Reeza — Thu, 29 Sep 2016 07:14:33 GMT

Have you tried a basic proc print, with BY groups?

Re: RTF in multiple pages

SJN — Thu, 29 Sep 2016 10:18:54 GMT

This is a Letter which has to be automated. Body of letter is same but customer name is different and every thing has to sent to customer in single RTF file.

Re: RTF in multiple pages

Reeza — Thu, 29 Sep 2016 11:49:07 GMT

Why not use Word MailMerge? It's built in and designed for exactly this.

in general before automating a process you need a working version, do you have that in place?

Startpage=yes allows you to control the page breaks.

Re: RTF in multiple pages

SJN — Thu, 29 Sep 2016 12:21:47 GMT

Yes I have body of the letter only need to add the customer details which is sas data set.

Re: RTF in multiple pages

Reeza — Thu, 29 Sep 2016 12:24:36 GMT

Can yo describe your process in detail, what you have and what's missing/need.

You can export SAS dataset and use Word directly. This could be automated via VBScript.

Or you could try and do it all in SAS.

Re: RTF in multiple pages

SJN — Thu, 29 Sep 2016 12:43:46 GMT

I have a body of letter and sas data set which contains customer names and there details (say address).

My requirement is in need to place the name of customer details along with body. I'm able to create for single customer but the problem I'm facing is not able to print for more than one customer in single word file.

Below the name and address I have take as input from SAS data set and populate. I need to create all the letters in single word file.

ex:

To,

<Name>

Dear Sir,

<Body>

Regards,

ABC Bank

Re: RTF in multiple pages

Reeza — Thu, 29 Sep 2016 17:39:01 GMT

I'd still recommend mailmerge.

Ok, put all your information in a data set, including the body of the letter and then use a custom data step that prints to the RTF doc to generate your letter.

Ie data set includes variables:

name address body

You may need to split the body into multiple variables to get the report the way you want.

Then use a BY Group per name/address as indicated earlier to get one page per report.

Re: RTF in multiple pages

SJN — Fri, 30 Sep 2016 05:16:55 GMT

Thank you Reeza for the Tip will try and let you know.