I have a program that creates multiple data sets(which I will call lists), each dataset gets formatted and has unique values that work like record numbers. Each list I designate a list_name and format and sort accordingly. I then create an aggregate table where all formatted tables are stacked together (I will call this the load file) My question is I need to back this up against a master data set, which is essentially the initial/original load file of this data located in oracle. Every day I need to see what records need to be added or removed in a master data set for each list_name in the current data run, meaning I generate this load file frequently and bump it up against the mater dataset. I need to flag those records (to be removed, to be added) in the load file, and create control stats table that essentially tabulates how many records were added or removed for each list. Attached is an example of the data. This is what the aggregate load file data generally looks like. (A) on excel attachment Below are counts for each 20 something lists in the load file:(B) on excel attachment Each list value is unique for that list_name, but a list_value can have multiples (belong to more than one list). To reiterate, I run for today's date, time stamp the data, run for each list name, then stack them all together. The goal is to take that stacked formatted load file and back it up against the master list, which shows the list_name, list_values for the prior run, bump current run, flag what records in the master list need to be added or removed. I need to create flags in the 'load file' to communicate with another group that manages the master list in oracle, so alternatives to this methodology aren't helpful. if I have access to the master file (e.g. sasdata.Master), how do I check the load file against sasdata.Master and flag which records are to be added or removed for each list in that load file so the folks managing sasdata.Master can update? Thank you in advance for your time and help!
... View more