ascending order error

[lgooseberry]

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]

Precede your code by proc sort:

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

[Tom]

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]

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