SAS xls export throws BOF record expected error

Anand08 — Wed, 28 Aug 2019 19:33:04 GMT

Hi,

I am trying to export a tables as xls and i use the following code

proc export data=metric_table outfile="/tmp/METRICS_&extractDate..xls"
label dbms=xls replace;sheet="Sheet1";
run;

i SFTP the file to the target team and when they try to import the data from the excel, they get and error BOF record expected.

when they copy the file to their desktop, open it and just save it, the import works fine. just wondering why the extract behaves in this manner

Re: SAS xls export throws BOF record expected error

SASKiwi — Wed, 28 Aug 2019 19:53:57 GMT

I suspect you need to do a BINARY SFTP rather than the default TEXT transfer.