topic Communication error when proc export large dataset in SAS Programming

Communication error when proc export large dataset

Q1983 — Sun, 07 Jan 2018 00:06:05 GMT

PROC EXPORT OUTFILE="\\corp\dfs\Mortgage_Shared\VA019\F01B\Everyone\Shared\Disaster\FEMA Disaster Servicing Loan Details_&mToday._&mTodayTS..xlsb"

DATA= purge.main_mostrecent_dr

DBMS= EXCELCS REPLACE;

SHEET='Loan Details';

SERVER='saspcff';

The above code is a 277K dataset which I am attempting to export as an xlsb file to a share drive. I believe due to the enormous size I keep getting the following error

ERROR: CLI disconnect failed: Server communication failure.

ERROR: Error in the LIBNAME statement.

I have a similar proc export with a much smaller size that writes to the same folder with no issues. Is it just an issue of timing out and is there a workaround coding wise

Re: Communication error when proc export large dataset

Reeza — Sun, 07 Jan 2018 00:36:26 GMT

How many variables do you have?

300K records isn't really that much to be honest and the file shouldn't be that large either unless you have hundreds of errors. I'm not also sure that SAS supports xlsB (Binary) files. What happens if you try and XLSX file?

@Q1983 wrote:

PROC EXPORT OUTFILE="\\corp\dfs\Mortgage_Shared\VA019\F01B\Everyone\Shared\Disaster\FEMA Disaster Servicing Loan Details_&mToday._&mTodayTS..xlsb"

DATA= purge.main_mostrecent_dr

DBMS= EXCELCS REPLACE;

SHEET='Loan Details';

SERVER='saspcff';

The above code is a 277K dataset which I am attempting to export as an xlsb file to a share drive. I believe due to the enormous size I keep getting the following error

ERROR: CLI disconnect failed: Server communication failure.

ERROR: Error in the LIBNAME statement.

I have a similar proc export with a much smaller size that writes to the same folder with no issues. Is it just an issue of timing out and is there a workaround coding wise

Re: Communication error when proc export large dataset

Kurt_Bremser — Sun, 07 Jan 2018 00:49:08 GMT

Excelcs might be limited to 64k rows.

Use a sensible, text based file format that has no such limitations for data transfer to/from another application.