Desktop productivity for business analysts and programmers

Report Formatting

Reply
Contributor
Posts: 73

Report Formatting


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


Report.png
Regular Contributor
Posts: 217

Re: Report Formatting

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

Grand Advisor
Posts: 17,466

Re: Report Formatting

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.

Ask a Question
Discussion stats
  • 2 replies
  • 304 views
  • 0 likes
  • 3 in conversation