SAS xls export throws BOF record expected error

[Anand08]

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

[SASKiwi]

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