I was wondering if anyone has come across the need to scan multiple directories/folders/libraries on their server in order to find and access the SAS datasets that live in those directories/folders. The tricky part is that these locations I am scanning all have different naming schema and as you move further into the directories/folders/libraries I am searching, the naming schema has no consistency at all. Ultimately I want to search every SAS data set in those directories/folders/libraries and see if they contain (or do not contain) specific variables. I need this to be an automated process that will run every day. My hunch is that it will be best to not hardcode anything if possible and use macro variables anywhere I can. Any help on how to solve this quandary would be most welcome. Code examples would be even better. I am a novice SAS user so I apologize if I did not use the correct terminology above. I am currently using SAS Enterprise Guide 7.11. Thanks in advance! - Mike
... View more