Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Best Practice for creating look-ups

Reply
Occasional Contributor
Posts: 11

Best Practice for creating look-ups

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.

 

Thanks!

Esteemed Advisor
Posts: 5,091

Re: Best Practice for creating look-ups

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
Post a Question
Discussion Stats
  • 1 reply
  • 128 views
  • 0 likes
  • 2 in conversation