Proc Export using xlsb

[Q1983]

data have;

input ln_no $ state $ loans amt;

datalines;

1123 AL 1 100

1123 AL 1 100

1123 AL 2 150

1233 AL 2 150

CA 3 50

;

run;

proc export data=have

outfile="\server\t_DATA_HIST.xlsb"

dbms=excelcs replace;

server= 'saspcff';

run;

I keep getting

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Excel Driver] Failure creating file.

ERROR: Error in the LIBNAME statement.

Is there special syntax that xlsb uses vs  xls and xlsx ????

[Larrihoover]

If you just want an xlsb file saved on the server you can use: proc export outfile="\server\t_DATA_HIST.xlsb" data = have replace DBMS=xls; run; Note that you get an error in your last datelines observation.