I need to query many address files to get a 5 year address history for a list of individuals. These SAS data files are organized in a folder structure when the folder name is based on when that file was last updated, e.g. d230821 for file updated 21 August 2023. In this folder would be a SAS data set that has the current addresses as of that update date for the individuals. For each individual, I need to get all address for a 5 year period relative to their birth date. Is there a way to create a macro to query these folders so that each folder does not need to explicitly linked to with a libname statement. I was thinking maybe something with the files metadata where I can compare the update date (in the folder name) with the individual's birthdate and only query that folder if it is within that 5 year window. There are 225 folders which is why I would like to come up with some sort of automated code. Hopefully this all makes sense. If not, please let me know and I will do my best to clarify. TIA!
... View more