Hello! I have two reports that I am trying to merge into one report. They both use the same data source. One report is quite simplistic (although very comprehensive) and shows graphs and tables. It has a report filter associated with it.
The second is more complex. The data source is aggregated into a new data set which is used to create graphs, tables etc. No filter is used at the report level, only parameters.
If I were to merge the two reports into one without further ado, report-level selections would affect the aggregated dataset, which would be inappropriate.
Any tips on how to proceed?
I guess one way is to use parameters for filtering, but that would be a big job to do.
Is this a SAS question? You don't really indicate that it is a SAS question.
If it is a SAS question, we would need you to provide example data (we don't need the whole data set) following these examples and instructions, and also screen capture of the two reports and some more detailed explanation of what the merged report would look like. Do not provide data in some other format, Excel files and screen captures of actual data are not acceptable. Screen captures of your reports are fine if you include them in your reply via the "Insert Photos" icon, do not attach files.
You are in the right place, but it helps if you specifically state you want to do this in SAS. People come in here occasionally with Excel questions, JMP questions, Scandinavian Airlines (also acronym SAS) questions, and so on. If it is not clear that you are using SAS, we ask. Anyway, you still need to provide more specifics about what merge you want to do, and some examples of the tables.
Would it be possible to move the current report-level filters to page-level filters and only put them on the pages that need to be filtered by those prompts? Alternatively, maybe you could keep the reports separate but provide a report link between them so they can be opened separately to avoid improper filtering.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.