Good Morning,
The goal of our new project is to make a list of all SAS files and perhaps text files contained in the main directories and all subdirectories. Then from that new list (put in a new dataset) , you must obtain the list of all the variables of each dataset of this list including the text file variables and put those variables into another datasets (global list). Subsequently, using this global list, you must scan certain key variables and retain the files containing these key variables in another table (new sas dataset).
The final goal is to trace any dataset that containts some policy information such as expired_date, expired_dt and so on and may be other key variable. Thereafter to delete from the actual dataset the policies which are expired since five years.
I have in mind a mix of Unix command and SAS Script.
The first steps is really to get the files listing with their path, file extension.
From there, I can use a macro functin to get the variables in each datasets, eliminate duplicate and so on.
How to get the variables list from a texte file ?
... View more
