Hi:    I show one approach to create several tables/reports (for RTF output) in my paper, Creating Complex Reports http://www2.sas.com/proceedings/forum2008/173-2008.pdf (page 9) .     TABULATE is another approach, but TABULATE does not give you as much control over break lines and spacing.     You'll find the programs that accompany the paper here: http://support.sas.com/rnd/papers/#RegUsers_2008 scroll down on the page for 2008 and look for the paper title.   This is just one idea. I second the idea of searching on www.lexjansen.com because the PharmaSUG and PhUSE presenters have talked a lot about producing these types of reports.   Cynthia ... View more

@Reeza- Thank you! I'll try. ... View more

Not by default, you need to use a process similar to what's shown which involves customizing the output to what you need. ... View more

Not sure what you need suggestions on: 1. create a template in Excel, with the report structure you want. 2. For the fields you need that are not formatted into a nice table, link them to cells behind the scene so you can export data from SAS straight into the template. 2. Use SAS to copy the template, FCOPY 3. Export data to the template for each report. First, get it working for one report and then work on automating the report. ... View more