topic Re: ERROR: An error has occurred while sorting a class interaction type in New SAS User https://communities.sas.com/t5/New-SAS-User/ERROR-An-error-has-occurred-while-sorting-a-class-interaction/m-p/559413#M10306 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? Thu, 16 May 2019 16:55:32 GMT Reeza 2019-05-16T16:55:32Z ERROR: An error has occurred while sorting a class interaction type https://communities.sas.com/t5/New-SAS-User/ERROR-An-error-has-occurred-while-sorting-a-class-interaction/m-p/559396#M10299 <P>Hello everyone,</P> <P>&nbsp;</P> <P>I am having an issue with a proc means with class specification.</P> <P>SAS log shows an error:</P> <P>&nbsp;</P> <P>ERROR: An error has occurred while sorting a class interaction type</P> <P>&nbsp;</P> <P>I tried sorting the dataset, reducing its size but it simply won't work.</P> <P>Any ideas on how to sort this problem?&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Thank you!</P> Thu, 16 May 2019 16:20:28 GMT https://communities.sas.com/t5/New-SAS-User/ERROR-An-error-has-occurred-while-sorting-a-class-interaction/m-p/559396#M10299 BchBnz 2019-05-16T16:20:28Z Re: ERROR: An error has occurred while sorting a class interaction type https://communities.sas.com/t5/New-SAS-User/ERROR-An-error-has-occurred-while-sorting-a-class-interaction/m-p/559400#M10300 How big is your data set? When you sorted did you switch to a BY statement instead of CLASS? Thu, 16 May 2019 16:27:55 GMT https://communities.sas.com/t5/New-SAS-User/ERROR-An-error-has-occurred-while-sorting-a-class-interaction/m-p/559400#M10300 Reeza 2019-05-16T16:27:55Z Re: ERROR: An error has occurred while sorting a class interaction type https://communities.sas.com/t5/New-SAS-User/ERROR-An-error-has-occurred-while-sorting-a-class-interaction/m-p/559412#M10305 <P>It's a bit more than 42GB. Yes, when I sorted it I used the BY statement.&nbsp;</P> <P>&nbsp;</P> Thu, 16 May 2019 16:52:42 GMT https://communities.sas.com/t5/New-SAS-User/ERROR-An-error-has-occurred-while-sorting-a-class-interaction/m-p/559412#M10305 BchBnz 2019-05-16T16:52:42Z Re: ERROR: An error has occurred while sorting a class interaction type https://communities.sas.com/t5/New-SAS-User/ERROR-An-error-has-occurred-while-sorting-a-class-interaction/m-p/559413#M10306 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? Thu, 16 May 2019 16:55:32 GMT https://communities.sas.com/t5/New-SAS-User/ERROR-An-error-has-occurred-while-sorting-a-class-interaction/m-p/559413#M10306 Reeza 2019-05-16T16:55:32Z Re: ERROR: An error has occurred while sorting a class interaction type https://communities.sas.com/t5/New-SAS-User/ERROR-An-error-has-occurred-while-sorting-a-class-interaction/m-p/559415#M10307 <P>I will try splitting the dataset.</P> <P>The SAS log doesn't report anything about memory!</P> <P>&nbsp;</P> <P>Thank you Reeza!</P> Thu, 16 May 2019 16:58:36 GMT https://communities.sas.com/t5/New-SAS-User/ERROR-An-error-has-occurred-while-sorting-a-class-interaction/m-p/559415#M10307 BchBnz 2019-05-16T16:58:36Z Re: ERROR: An error has occurred while sorting a class interaction type https://communities.sas.com/t5/New-SAS-User/ERROR-An-error-has-occurred-while-sorting-a-class-interaction/m-p/559419#M10310 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/7188">@BchBnz</a>&nbsp;wrote:<BR /> <P>I will try splitting the dataset.</P> <P>The SAS log doesn't report anything about memory!</P> <P>&nbsp;</P> <P>Thank you Reeza!</P> <HR /></BLOCKQUOTE> <P>Are you running this to create a dataset? Using NOPRINT option?</P> <P>Maybe the issue is many class variables and the table generator for results is getting tangled and not actually a "sort" issue.</P> <P>And what ODS destination is involved?</P> <P>&nbsp;</P> Thu, 16 May 2019 17:10:16 GMT https://communities.sas.com/t5/New-SAS-User/ERROR-An-error-has-occurred-while-sorting-a-class-interaction/m-p/559419#M10310 ballardw 2019-05-16T17:10:16Z Re: ERROR: An error has occurred while sorting a class interaction type https://communities.sas.com/t5/New-SAS-User/ERROR-An-error-has-occurred-while-sorting-a-class-interaction/m-p/559420#M10311 <P>Hello ballardw,</P> <P>&nbsp;</P> <P>I am using the NOPRINT option and OUTPUT OUT statement.&nbsp;</P> <P>I have 3 classes, which worked for other datasets.&nbsp;</P> Thu, 16 May 2019 17:13:10 GMT https://communities.sas.com/t5/New-SAS-User/ERROR-An-error-has-occurred-while-sorting-a-class-interaction/m-p/559420#M10311 BchBnz 2019-05-16T17:13:10Z