RTF in multiple pages

SJN · Posted 09-29-2016 02:19 AM

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.

Reeza · Posted 09-29-2016 03:14 AM

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

SJN · Posted 09-29-2016 06:18 AM

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.

Reeza · Posted 09-29-2016 07:49 AM

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.

SJN · Posted 09-29-2016 08:21 AM

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

Reeza · Posted 09-29-2016 08:24 AM

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.

SJN · Posted 09-29-2016 08:41 AM

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

Reeza · Posted 09-29-2016 01:39 PM

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.

SJN · Posted 09-30-2016 01:16 AM

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

RTF in multiple pages

Re: RTF in multiple pages

Re: RTF in multiple pages

Re: RTF in multiple pages

Re: RTF in multiple pages

Re: RTF in multiple pages

Re: RTF in multiple pages

Re: RTF in multiple pages

Re: RTF in multiple pages

🚨 Early Bird Rate Extended!

SAS Training: Just a Click Away