BookmarkSubscribeRSS Feed
AbhinavDixit
Fluorite | Level 6

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
6 REPLIES 6
ballardw
Super User

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

AbhinavDixit
Fluorite | Level 6
I have around 297,573 records with 20 variables

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

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
Fluorite | Level 6
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
Opal | Level 21

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
Super User

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. 

 

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 3169 views
  • 0 likes
  • 4 in conversation