DATA Step, Macro, Functions and more

Proc Export using xlsb

Reply
Regular Contributor
Posts: 178

Proc Export using xlsb

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

Occasional Contributor
Posts: 16

Re: Proc Export using xlsb

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.
Ask a Question
Discussion stats
  • 1 reply
  • 178 views
  • 0 likes
  • 2 in conversation