topic Re: ascending order error in SAS Programming

ascending order error

lgooseberry — Wed, 04 Nov 2020 19:40:50 GMT

I keep receiving the error:

Proc means data= bmi_smoke mean stddev;

89 class BMI;

90 by sex;

91 Run;

ERROR: Data set WORK.BMI_SMOKE is not sorted in ascending sequence. The current BY group has sex = 2 and the next BY group has sex

= 1.

i'm just trying to figure out how to get the mean and standard deviation of the BMI by sex.

any ideas?

Shmuel — Wed, 04 Nov 2020 19:46:11 GMT

Precede your code by proc sort:

proc sort data=bmi_smoke ;
 by sex bmi;
run;

Tom — Wed, 04 Nov 2020 20:12:33 GMT

Sounds like you want BMI on the VAR statement. Put SEX on the CLASS statement, instead of trying to use a BY statement.

proc means data= bmi_smoke mean stddev;
  class sex;
  var BMI; 
run;

lgooseberry — Wed, 04 Nov 2020 21:56:18 GMT

thanks Tom! that helped! do you know if i am able to find out the 95% confidence interval level in that code as well?