Sorry for any confusion: 1) Will have CSV files in a folder that all follow similar naming conventions & all follow similar format 2) Mass import into SAS as tables 3) Identify changes from successive tables (changes from 1 to 2, 2 to 3, 3 to 4 & so on...) 4) The more recent file will always be the 'source of truth' 5) Create a table that includes all changes The 3 types of changes: Additions -- on file 2, not on file 1 Removals -- on file 1, not on file 2 Adjustment -- name is on both, but weight has been adjusted You should really include at least one example of some thing changes more than one time and what the result looks like -- this will always just be based on 2 files. Does this help answer the questions?
... View more