Hi Cynthia, My apologize on the inadequate screenshot. Yes as seen below, I followed your advice and steps for creating the all_excel folder and moved my file to it. In the meantime, I decided to take a chance and changed the extention to an older version .xls file. When I ran it again, it said to save in an Excel format ver. 5 or later. So I took a chance and saved it as a .csv file and it worked! I'm not sure how but it may have something to do with the ..xlsx and .xls file ext that SAS did not like? Maybe it was the way that Pentaho created the XML file? Not sure but would like to find an answer because that was strange! Thank you so very much for your help!!
... View more