topic Re: Multiple tables summary in one report in SAS Visual Analytics

Multiple tables summary in one report

vallsas — Wed, 30 Mar 2022 12:59:08 GMT

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.

Re: Multiple tables summary in one report

Renato_sas — Thu, 31 Mar 2022 14:43:28 GMT

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?

Best,

Renato

Re: Multiple tables summary in one report

vallsas — Fri, 01 Apr 2022 10:28:20 GMT

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.

Re: Multiple tables summary in one report

Renato_sas — Fri, 01 Apr 2022 11:48:37 GMT

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.

Best,

Renato