Problem in exporting data to existing xlsb file on server

[Abhinav26]

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.

[Jagadishkatam]

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

[Kurt_Bremser]

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.