topic Re: The data set is not sorted in ascending sequence. in New SAS User

The data set is not sorted in ascending sequence.

Martina4 — Wed, 14 Nov 2018 02:32:08 GMT

Hello all,

I am trying to gather the means and standard errors of my treatments for my data. I have entered the following code...

proc means data=WORK.yr1_2016 mean stderr;
var totyd sorgyd weedyd legyd;
by leg;
output out = b mean=totalydX sorgydX weedydX legydX stderr=totalydSE sorgydSE weedydSE legydSE;
run;

However, I keep receiving the following error message when I try to run it...

ERROR: Data set WORK.YR1_2016 is not sorted in ascending sequence. The current BY group has leg = RHL and the next BY group has leg

= ALF.

This experiment is a randomized split-plot arrangement. There are six main plots listed under "leg" and the six plots are ALF, BFT, IBF, PPC, RD, RHL. And then there are four split plots listed under CC and these are 1, 2, 3, and 4. There is a significant leg*CC interaction if this makes any difference in the above coding.

Thank you!

Re: The data set is not sorted in ascending sequence.

Reeza — Wed, 14 Nov 2018 02:46:43 GMT

If you use a BY statement you do have to sort your data so that the BY groups are in order in your data. If you do not want to dot his for some reason you can switch By to CLASS.
For the sort, just make sure your BY statement is the same in the proc as in PROC SORT.

proc sort data=yr1_2016;
by leg; run;

Note that you do not need to specify the statistics in the PROC MEANS statement, this only controls the displayed output.

Re: The data set is not sorted in ascending sequence.

Astounding — Wed, 14 Nov 2018 03:17:07 GMT

Also note, if you switch from BY to CLASS:

class leg;

The CLASS statement produces extra summarizations that you would not otherwise get. If you want just a summarization for each LEG, you have to apply the nway option:

proc means data=WORK.yr1_2016 nway;

Re: The data set is not sorted in ascending sequence.

kyle2356 — Mon, 02 May 2022 11:54:22 GMT

Thank you so much, I'm new to SAS and this was really helpful for my purposes.

Re: The data set is not sorted in ascending sequence.

PaigeMiller — Mon, 02 May 2022 12:03:11 GMT

@Martina4 wrote:

This experiment is a randomized split-plot arrangement. There are six main plots listed under "leg" and the six plots are ALF, BFT, IBF, PPC, RD, RHL. And then there are four split plots listed under CC and these are 1, 2, 3, and 4. There is a significant leg*CC interaction if this makes any difference in the above coding.

While this description doesn't directly indicate any sorting, you can also try

by leg notsorted;

This requires all the RHL to be consecutive and all the ALF to be consecutive, and so on.