Proc Export using xlsb

Q1983 — Thu, 22 Feb 2018 19:49:14 GMT

data have;

input ln_no $ state $ loans amt;

datalines;

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 ????

Re: Proc Export using xlsb

Larrihoover — Thu, 22 Feb 2018 21:25:53 GMT

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.

topic Proc Export using xlsb in SAS Programming

Proc Export using xlsb

Re: Proc Export using xlsb