BookmarkSubscribeRSS Feed
noobs
Calcite | Level 5


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
2 REPLIES 2
jwillis
Quartz | Level 8

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

Reeza
Super User

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 875 views
  • 0 likes
  • 3 in conversation