BookmarkSubscribeRSS Feed
Pyrite | Level 9

Dear All,

I have 20 tables and i would like to create a summary report on

as 20 tables i can't join as they are diff tables no common columns.

so 4 tables they have common columns and like that i can create 

four summary tables (like they contain, count of bags, shoes in one table,

other table count of laptops,count of mobiles, other table count of books and number of subjects)

so here the challenge is I want to create a one report alltogether in va 

so the user should be able to all the stats in one report .as they dont have common id to join.


please let me know if you brilliant ideas. 


SAS Employee

Hi @vallsas,

If the tables don't have a key to be joined, that's an indication that they shouldn't be joined. Would it make sense to append those tables outside of VA instead? If the tables have no common columns like you said, maybe a bit of data prep to standardize them before the append?



Pyrite | Level 9

Hi Renato,

thank you.

Yes, i had the same feeling but i thought to check as va can get access multiple tables in one report without join (correct me).


thank you again for the clarification and reply.

SAS Employee

Just to clarify, a VA report can access multiple tables, but each VA object (bar chart, crosstab, etc.) can be fed by only one table.






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!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 3 replies
  • 1 like
  • 2 in conversation