BookmarkSubscribeRSS Feed
debopriya85
Calcite | Level 5

Hi, I am new to SAS dashboards and currently using SAS Viya 3.4

For one of the dashboards, I need to calculate event rate which is "count(event id)/ Count(all component)"

now, count event ID is coming from a fact table which is having 2.7million records (around 7 GB).

and the denominator Count(All component) is coming from another table which is having 700K records

when I left join these 2 tables (left table is the 700K records table) and create another table the table size grows to 64 GB, which causes a massive slowdown.

Is there any better way of doing things.

 Appreciate your suggestion. Let me know if anything is not clear

Thanks!

2 REPLIES 2
SASKiwi
Opal | Level 21

Doesn't sound like the join is working correctly. I would expect your new table to contain 2.7m rows with the extra All Component count tagged on the end so you can do the calculation. If that is not what you are seeing then you need to review your query. You'll need to provide more details of your data if you need more help.

acordes
Rhodochrosite | Level 12

Also it's a nice feature to perform joins directly in Visual Analytics, I wouldn't recommend to do so if big tables are involved. 

It's a better approach to join outside like in 'sas studio' or 'data studio'. 

And try creating aggregated data tables in VA prior de joining. then it will be fast.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

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
  • 2 replies
  • 209 views
  • 0 likes
  • 3 in conversation