Data visualization with SAS programming

RTF in multiple pages

Reply
Contributor SJN
Contributor
Posts: 20

RTF in multiple pages

[ Edited ]

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.

Grand Advisor
Posts: 16,311

Re: RTF in multiple pages

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

Contributor SJN
Contributor
Posts: 20

Re: RTF in multiple pages

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.

Grand Advisor
Posts: 16,311

Re: RTF in multiple pages

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. 

 

 

Contributor SJN
Contributor
Posts: 20

Re: RTF in multiple pages

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

Grand Advisor
Posts: 16,311

Re: RTF in multiple pages

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. 

 

 

Contributor SJN
Contributor
Posts: 20

Re: RTF in multiple pages

[ Edited ]

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>

<Address>

 

Dear Sir,

<Body>

 

Regards,

ABC Bank

 

 

Grand Advisor
Posts: 16,311

Re: RTF in multiple pages

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.

Contributor SJN
Contributor
Posts: 20

Re: RTF in multiple pages

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

Post a Question
Discussion Stats
  • 8 replies
  • 361 views
  • 3 likes
  • 2 in conversation