BookmarkSubscribeRSS Feed
Obsidian | Level 7

Good morning!

I have a master dataset (30+ million records) that updates every quarter. I also have a look-up table with about 900 records in it that updates every 2 weeks. I would like to know from others the best way to create a look-up between the values in both datasets without having to re-load the master dataset. I have reviewed the process for using a join, create view and formats. Any expert and practical advice is much appreciated!


I am currently using SAS VA version 7.3.



Tourmaline | Level 20
Reload a table of that size every two weeks doesn't sound like an issue ix you don't have extreme 24/7 requirements.
Formats saves memory but there have been some quality issues with then in the product. Not sure if all those are fixed in 7.3.
What do you mean by a view? A star schema? That could work fine if the usual query results in small subsets.
Data never sleeps



Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.


Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 


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
  • 1 reply
  • 2 in conversation