Hello  Can anyone offer an option for dealing with Excel files that contain merged rows as the Headers? I am using base SAS 9.4.   The files I am working with are collected daily. I need to create a way to remove the merge and reformat the rows.  Importing and deleting is not an option due to SAS reading the rows below the headers as text during the import.   I have a second issue, if anyone can offer an idea of how to deal with it. A different Excel file has the first row blank.      Is there a way to delete the first row without using the import function?   Thank for any help you can offer.        ... View more