My excel input contain 24 fields. One of the cells in the excel sheet is paths of file. and their will be multiple paths separated by linefeed. The number of file paths in each cell differs. In another cells holds multiple file names. The number of file names in each cell differs. I did import the excel sheet to a sas dataset. The object of the program is- whenever a new row is added to the excel sheet, if the added date is <=today()-1, then check for duplicates in the filename, if true check for duplicate file paths. I need help in resolving this oiissue.
... View more