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.
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?
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.
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.