topic Re: Problem in exporting data to existing xlsb file on server in SAS Programming

Problem in exporting data to existing xlsb file on server

Abhinav26 — Thu, 18 Jun 2020 07:40:21 GMT

25 GOPTIONS ACCESSIBLE;
26 proc export outfile="/temp/myloc/dev/nonp/output/auto/sas/testing.xlsb"
27 data = one replace
28 DBMS=xls;
29 sheet="Sheet1";
30 run;

File is not OLE2
Requested Input File Is Invalid
ERROR: Export unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.

Re: Problem in exporting data to existing xlsb file on server

Jagadishkatam — Thu, 18 Jun 2020 07:46:08 GMT

Could you please update the DBMS=EXCELCS and try if it resolves the issue, also check if the file path is correct and it is .xlsb and not .xlsx

Re: Problem in exporting data to existing xlsb file on server

Kurt_Bremser — Thu, 18 Jun 2020 08:11:51 GMT

According to the documentation, .xlsb files can only be used with the EXCEL and EXCELCS engines. For EXCELCS, you need a PC Files Server. .xlsb files need the Microsoft ACE Driver, which is available on Windows only.