BookmarkSubscribeRSS Feed
BchBnz
Obsidian | Level 7

Hello everyone,

 

I am having an issue with a proc means with class specification.

SAS log shows an error:

 

ERROR: An error has occurred while sorting a class interaction type

 

I tried sorting the dataset, reducing its size but it simply won't work.

Any ideas on how to sort this problem? 

 

 

Thank you!

6 REPLIES 6
Reeza
Super User
How big is your data set? When you sorted did you switch to a BY statement instead of CLASS?
BchBnz
Obsidian | Level 7

It's a bit more than 42GB. Yes, when I sorted it I used the BY statement. 

 

Reeza
Super User
That's annoying. If it sorted it should definitely be able to do a proc means. Not a great idea but you can split it up and merge the results if needed. Any chance you're running into memory issues?
BchBnz
Obsidian | Level 7

I will try splitting the dataset.

The SAS log doesn't report anything about memory!

 

Thank you Reeza!

ballardw
Super User

@BchBnz wrote:

I will try splitting the dataset.

The SAS log doesn't report anything about memory!

 

Thank you Reeza!


Are you running this to create a dataset? Using NOPRINT option?

Maybe the issue is many class variables and the table generator for results is getting tangled and not actually a "sort" issue.

And what ODS destination is involved?

 

BchBnz
Obsidian | Level 7

Hello ballardw,

 

I am using the NOPRINT option and OUTPUT OUT statement. 

I have 3 classes, which worked for other datasets. 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 6 replies
  • 1943 views
  • 0 likes
  • 3 in conversation