Exception thrown while executing Proc Procedures

[AbhinavDixit]

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

[ballardw]

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

[AbhinavDixit]

I have around 297,573 records with 20 variables

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

[Reeza]

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. 

[AbhinavDixit]

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. -##

[Patrick]

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.

[Reeza]

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.