topic Re: Exception thrown while executing Proc Procedures in SAS Programming

Exception thrown while executing Proc Procedures

AbhinavDixit — Mon, 03 Oct 2016 17:52:12 GMT

Hello,

I need a small help, when executing SAS PROC procedures like PROC REPORT or PROC SQL in SAS University Edition, an Excpetion is thrown stating, "An excpetion was thrown while sending packet to the peer."

Don't know the reason behind this. (The data I am executing is very large)

The failed execution and excpetion is becuase of large volume data.

Please share youe expert reviews for the same

Thanks in advance

Re: Exception thrown while executing Proc Procedures

ballardw — Mon, 03 Oct 2016 19:18:33 GMT

How large is "very large", numbers of records and variables?

Re: Exception thrown while executing Proc Procedures

Reeza — Mon, 03 Oct 2016 19:52:34 GMT

SAS UE isn't designed for large data sets. Options to try and work around are to increase the RAM available if it's a memory intensive proc. This would be in your VM settings.

Re: Exception thrown while executing Proc Procedures

AbhinavDixit — Tue, 04 Oct 2016 04:47:33 GMT

I have around 297,573 records with 20 variables

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: Exception thrown while executing Proc Procedures

Reeza — Tue, 04 Oct 2016 05:52:05 GMT

That's not a big dataset. I've used SAS UE on several million rows.

Restart your VM.

Restart everything in fact and clear your cache.

Then try again. If it doesn't work post the code and error.

Re: Exception thrown while executing Proc Procedures

AbhinavDixit — Tue, 04 Oct 2016 07:52:45 GMT

H Reeza
yes i already did that.
Reinstalled everything and even cleared my cache. But getting same error
(Snapshot I have already shared before)

Thanks in advance

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: Exception thrown while executing Proc Procedures

Patrick — Tue, 04 Oct 2016 08:01:43 GMT

Does it work if you run the exactly same code with much less data?

I believe SAS UE has a limitation of 1GB for SAS tables so if your variables are very generously assigned character vars then you could hit the limit.