BookmarkSubscribeRSS Feed
Quartz | Level 8


We are trying to remove our Excel based reports and push out all our reports using SAS Web Report Studio.

As our first step, we wish to replicate what we had in Excel, that is a pivot table.

To do this, I've built a cube in DI Studio, and built a report off that in SAS Web Report Studio.  My background is using Cognos PowerPlay Transformer, so I'm somewhat comfortable with cubes.  I'll try Information Maps next, but I've never really created one before.

I'm largely happy with the report, with the exception of the filtering options.  Is there an option to have a couple of variables sitting ontop of a table, click on it, and select what values we want filtered?  Or would it be a case of editing the report, putting on the filter and viewing the report?  I don't think I want to create a different section for each value in a variable.


Quartz | Level 8

Would a dynamic prompt attached to a filter do what you want, this would however require a Information Map I think.

Not exactly what you describe but I think would produce a filtered report.


Quartz | Level 8

Hi Barry,

Dyamic prompts attached to a filter was as close as I could get to finding a solution too.  I don't want this, as the majority of times, the user will not know what filters they want applied until they've seen the data. 

If the solution to what I want require Information Maps I don't mind using them.

It sounds as though the feature I'm afer doesn't exist.



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg



Back in the Classroom!

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

View all other training opportunities.

Discussion stats
  • 2 replies
  • 2 in conversation