DATA Step, Macro, Functions and more

Exception thrown while executing Proc Procedures

Reply
New Contributor
Posts: 3

Exception thrown while executing Proc Procedures

[ Edited ]

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


Exception.PNG
Super User
Posts: 10,516

Re: Exception thrown while executing Proc Procedures

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

New Contributor
Posts: 3

Re: Exception thrown while executing Proc Procedures

I have around 297,573 records with 20 variables

##- Please type your reply above this line. Simple formatting, no
attachments. -##
Super User
Posts: 17,864

Re: Exception thrown while executing Proc Procedures

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. 

New Contributor
Posts: 3

Re: Exception thrown while executing Proc Procedures

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. -##
Respected Advisor
Posts: 3,895

Re: Exception thrown while executing Proc Procedures

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.

Super User
Posts: 17,864

Re: Exception thrown while executing Proc Procedures

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. 

 

 

Ask a Question
Discussion stats
  • 6 replies
  • 407 views
  • 0 likes
  • 4 in conversation