Reeza, I have attached the latest code along with error messages, the file name is "All Channels" to my original post - Thanks, K. When I try to attach a file, i get beloe Attach Files                                Max Size: 1.0 K                                , File types allowed: No file types allowed ... View more

You are posting too much code and it keeps getting garbled.  Reduce the code to the minimum steps that produce the problem.  You might even lose some of the comments if it will make the code easier to post. Can't you just paste it as plain text?  Or paste it into WORD first and then copy and past from there. Unless you are running some really old version of SAS you should change from DBMS=EXCEL to DBMS=XLSX. Bascially if you are importing a modified XLSX file and the target SAS datasets is NOT changing then there are only a few things that can be going wrong. 1) the IMPORT step did not run and so the SAS dataset is not modified.  This is what your original post seems to show since SAS provided you with a nice error message saying it could not find the file you wanted to import. 2) You are NOT importing the changed file.  Are you sure you changed the file?  Perhaps you saved it somewhere else?  Is it possible there is some type of caching going on so that the SAS server is not seeing the changed file? ... View more