BookmarkSubscribeRSS Feed
vallsas
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. 

 

3 REPLIES 3
Renato_sas
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?

Best,

Renato

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

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

 

Best,

Renato

SAS Innovate 2025: Register Now

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!

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
  • 1040 views
  • 1 like
  • 2 in conversation