topic Report Formatting in SAS Enterprise Guide

Report Formatting

noobs — Tue, 08 Apr 2014 17:29:26 GMT

Hello EG Users,

I need advice trying to figure out if it is possible to layout this kind of format using tools available in SAS EG. Attached is snapshot of what I intend to build. It is void data.

But what I would like to stress is the way certain rows are bold and the secondary description (Total FTE, Traditional CLasses FTE, etc). Also way to add the line between each section.

I have been playing around with Summary Tables Wizard and List Data under Tasks but to no avail.

Is this kind of reporting possible in Web Report Studio?

Btw, this has been generated in Microsoft Excel

Thanks,

Dhanashree

Re: Report Formatting

jwillis — Tue, 08 Apr 2014 17:56:30 GMT

Google "SAS Traffic Lighting". There are ways to do what you want with Formats and Procedure options.

Re: Report Formatting

Reeza — Tue, 08 Apr 2014 18:54:52 GMT

Yes there are ways to do this, but it usually doesn't happen in EG via the point-click method, you'll have to program the details in yourself.

You should be able to replicate that report exactly, to either Excel, PDF or RTF files using a combination of data steps, proc tabulate and proc report.

You can get pretty close to that by using proc tabulate, but you'll need to organize your data in a specified way.

As always, easier to provide more detailed tips/hints with sample input and output data.