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 — Thu, 21 Mar 2019 18:04:14 GMT

Hello all,

I am trying to gather the means and standard errors of harvest yields from my data. I have entered the following code...

proc sort data=WORK.SSG2016harvests;
by legume trt harvest;
proc means data=WORK.SSG2016harvests mean stderr;
var sorgyd;
by harvest;
output out = c mean=sorgyd sorgSE;
run;

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

ERROR: Data set WORK.SSG2016HARVESTS is not sorted in ascending sequence. The current BY group has Harvest = Total and the next BY group has Harvest = 1.

There are 5 different harvests labeled as 1, 2, 3, 4, total.

I am stumped on how to solve this, and appreciate some input!

Thank you!

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

PaigeMiller — Thu, 21 Mar 2019 18:14:13 GMT

Total sorts after the numbers, in the default SAS sort order.

So, when total comes first, it is not in the proper sorted order.

To fix this, use either:

by harvest notsorted;

class harvest;

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

Astounding — Thu, 21 Mar 2019 18:38:05 GMT

There are two issues to attend to. First, what groupings do you want statistics for? For each harvest? Then use:

by harvest;

But use that in BOTH procedures, don't change it from one procedure to the next. On the other hand, if you want separate statistics for each treatment within each procedure, use:

by trt harvest;

Again, use the same BY statement for BOTH procedures.

The other issue is the request for the standard errors. You have to specify which statistic you are asking for. So the OUTPUT statement would look like this:

output out=c mean=sorgyd stderr=sorgSE;