This is for example the data:
dataset1: customer
dataset2: customer characteristics
On one page I have the customer list table with a filter (the filter contains different attributes than the customer characteristics table).
The second page contains the customer characteristics. So I link the first page to the second, so when I double click on the first page I get the result for each customer characteristics on the second.
But I also want to view all the customer characteristics that are showed on the first page (by the filter).
The purpose of that is that you can download an excel for each page and you have all the data in two excelsheets.
I tried to make a third page, but if I change the primary keys in the page links, it would also change the page link from the first to the second.
There is probably a way where 2 and 3 dont have to be in separate page.
What sas platform do you use?
What are the excel versions - is it a .xls or .xlsx files?
Are the two tables in different excel files or two sheets in one file?
Can you write or run your own sas base code?
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.