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.
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.
09-29-2016 08:41 AM - edited 09-29-2016 08:43 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.
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.