Hi Reeza, Thank you !!! My code :- It detemines all the .xlsx and Xls file data _Null_; Call system("find &filedir1. . \( -name \*.xls -o -name \*.xlsx \) -print> /Santosh/exls.csv"); run; The out put of hte above will have a list of all hte xlsx,xls files, my code reads all the files listed sequentially, but now i need to compare the files v,v1 and v2 and append only hte dataset which has the highest count to the Master data set and should also compare the names of the files used. Sales_Detls_201607.xls Sales_Detls_201607_Upd_V1.xls Sales_Detls_201607_Upd_V2.xls for example we recieved three files for any month now after the datasets are checked for the record how do i append the dataset containing highest records for the same period of time.
... View more
