Hi, I need filter my datas from name of files which are copied in the system. These files are sometimes renamed and somtimes not. These files are named like that "201905061636XXXXXXXX65562.xls" but the length of the name is not always the same. In the beginning of the name, there is the date and the hour when the file was loaded so the length is always the same. XXXXX is the name of the client and the length changes. Then there are numbers at the end of the file and, sometimes, when the file have been manually modified, there letter like "Modify" or "test" or "testV2", "modifyV2" etc... after this last numeric string... I would like to cut these strings to identify the date and time in a single variable then the name of the client and the the last number writen in the name file. I dont want words like "Modify" or "Test" at the end. I can't find how to do that. I guess I can use Scan function or something like that but I have no idea how to use a sas function with that kind of variable. Of course I get the date and time with: date=substr(name,1,12) as the length is always the same but I don't know what to do with the other parts I need. thanks
... View more
