06-29-2016 11:45 AM
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.
06-29-2016 06:04 PM