I am hoping on some advice on the following. Currently, we are trying to make a report on the performance of several teams. The current report is in Excel and results in a single page for each team with two graphs and two tables in a 2 x 2 setup on a page. Making this report in SAS EG based on the same data is not hard. We have added a parameter (we still use SAG EG 4.1) to select the team. Based on this parameter I generate the two tables and the two tables for the specified team. This leads us to the challenging part. The SAS EG installation is a local one, so we do not have Web Report Studio or anything like that. The most convenient way of distributing the reports to the end users is to make a PDF file containing all data for the different teams, with each team on a separate page. However, we have not been able to work out how to do this easily. Is their a way to generate a report for each possible value of a parameter and combine those into a single report? Alternatively, we have tried to generate the separate graphs and tables using a BY-variable (i.e. the team). However, we haven't succeeded in combining those into a report in such a way that all graph / tables belonging to one team are on the same page. This seems only to be possible if you only have two items that you can put next to each other on a page, but not in a 2 x 2 setup on a page. Are we missing something here? Does anyone have a way in which we can achieve what we want or is what we want not possible? If so, does anyone have any good suggestions for alternatives? Aside from buying a SAS server with Web Report Studio :-)...
... View more