I don't understand the functional difference between the files - is Agency the same as Location - the two provider IDs (MET and IC) the same? Why is data in one file but not the other - that will help me understand what you are trying to do.
Sorry this has taken me so long to respond but I have been out on sick leave. I will try and answer your quesions as you have them listed.
1. is Agency the same as Location? No, Agency is the name of the actual agency and location is a geographical location where the agency is found in the city.
2. the two provider IDs (MET and IC) the same? Yes, Met -short for Metro will have all the providers listed in the metro area and IC (Inner City) is a subset of Met.
3. Why is data in one file but not the other? Good question, as the subsets (IC) are suppose to report what clients they have. This is part of my dilemma as I am trying match on who what agency has reported to get a client count and who has not reported. I hope this helps and let me know if you need further information.
Again, I apologize for the delay.