topic Re: Error when trying to export Model to CSV file in SAS Programming

Error when trying to export Model to CSV file

pedrohjesus — Thu, 14 Apr 2022 15:49:12 GMT

Gentlemen, I am a novice Viya 4 admin in my company. A developer user reported the following error when trying to run the following command.

FILENAME REFFILE FILESRVC FOLDERPATH="/Users/E040017/Lpa_Cartao/saida" FILENAME='dataset_train_teste_5_novo.csv';
proc export data=work.lim_disp_final
    outfile=REFFILE
    dbms=csv
    replace;
run;

The error returned is as below:

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to 
WORK.PARMS.PARMS.SLIST.
ERROR: Call to tcpSockContinueSSL failed.
ERROR: The Files Service request returned HTTP status 100: Continue.
ERROR: Unexpected HTTP status from the Files Service request.
ERROR: The Files Service failed to update the file 'dataset_train_teste_5_novo.csv'.
3261297 records created in REFFILE from WORK.LIM_DISP_FINAL.

I searched for this error in the forum, but none applied. I also checked the File Service settings in the SASEnvironmentManager, but it didn't seem to be the cause of the error.

Any help or pointers for this case?

Thank you in advance.

Re: Error when trying to export Model to CSV file

Tom — Thu, 14 Apr 2022 15:56:42 GMT

Are you using WINDOWS servers?

https://support.sas.com/kb/62/089.html#:~:text=ERROR%3A%20Call%20to%20tcpSockContinueSSL%20failed,problem%20occurs%20only%20post%2Ddeployment.

Is there enough spaces in that location for millions of lines of text you are trying to write?

Re: Error when trying to export Model to CSV file

pedrohjesus — Thu, 14 Apr 2022 16:55:19 GMT

No, we are using Linux.

This path "/Users/E040017/Lpa_Cartao/saida" is in the SAS Content directory of SAS Studio.
How can I check SAS Content space ?

Re: Error when trying to export Model to CSV file

pedrohjesus — Thu, 14 Apr 2022 18:21:16 GMT

We noticed that it's actually because of the file size. How can we fix this without changing modifying the file?

Re: Error when trying to export Model to CSV file

Tom — Thu, 14 Apr 2022 19:19:15 GMT

If the issue is that the target disk does not have enough space then allocate more space. Or target a different location.

Or try using the ZIP fileref engine to write a compressed file. Not sure if that will work you since you appear to possible be using VIYA or some other strange setup instead of just running SAS with direct access to disks for writing your data.