Hi,
I am trying to create a report in SAS Visual Analytics Report, using two tables. I have two tables. i can create graph, list, crosstabs seperately using each table in one section, but is it possible that i can create a single list or crosstab using both tables? Tables has some common fields, not all.
table one.
Year, location, population
Table two
Year, location, disease name,confirm/suspected, numberof cases
So, both table has year and location common. I wanted to get population from table one to table two crosstab.
Any idea how i can do that?
Thanks
Badal
badal:
The way SAS Visual Analytics is designed, each visualization on the same page/section can point to different data tables, but within the same visualization itself, all the variables/columns must come from the same data table.
If you are linking from Visualization1 (DataTable1) to Visualization2 (DataTable 2) within the same page/section (ala Interactions), or to a different page/section (same report), or to a different page/section (completely different report), you would be prompted to map the source table/variable to the target table/variable.
However, only visual display items in Visualization1 (DataTable1) - the source - can interact/link up with Visualization2 (Data Table2) - the target. It is not possible to interact/link up items not currently showing within Visualization1 (Data Table1) and expect a linkage with Visualization (Data Table 2).
Sincerely,
Ted Stolarczyk, SAS Customer Loyalty team
badal:
The way SAS Visual Analytics is designed, each visualization on the same page/section can point to different data tables, but within the same visualization itself, all the variables/columns must come from the same data table.
If you are linking from Visualization1 (DataTable1) to Visualization2 (DataTable 2) within the same page/section (ala Interactions), or to a different page/section (same report), or to a different page/section (completely different report), you would be prompted to map the source table/variable to the target table/variable.
However, only visual display items in Visualization1 (DataTable1) - the source - can interact/link up with Visualization2 (Data Table2) - the target. It is not possible to interact/link up items not currently showing within Visualization1 (Data Table1) and expect a linkage with Visualization (Data Table 2).
Sincerely,
Ted Stolarczyk, SAS Customer Loyalty team
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 25. 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.