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

[BchBnz]

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!

[Reeza]

How big is your data set? When you sorted did you switch to a BY statement instead of CLASS?

[BchBnz]

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

[Reeza]

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]

I will try splitting the dataset.

The SAS log doesn't report anything about memory!

Thank you Reeza!

[ballardw]

---

@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]

Hello ballardw,

I am using the NOPRINT option and OUTPUT OUT statement. 

I have 3 classes, which worked for other datasets.