When reading and writing data to Microsoft Excel and Microsoft Access files using the EXCELCS, ACCESSCS, or PCFILES engines, the following errors can occur:
ERROR: A pipe communications routine failed: The pipe has been ended. (109)
ERROR: A pipe communications routine failed: The pipe is being closed. (232)
ERROR: A pipe communications routine failed: The pipe is being closed. (232)
ERROR: CLI error trying to establish connection: Server communication failure.
ERROR: Error in the LIBNAME statement.
ERROR: Connection Failed. See log for details.
To circumvent this issue, use the SAS XLSX engine or the Microsoft Engines (EXCEL or ACCESS).