Proc report-formatting

[robertrao]

Hi,

This is a part of the proc format ;

I want in this order when i generate the report.

VALUE BMIFMT

0-18.49="Underweight"

18.50-24.99="Normal"

25-29.99="Overweight"

30-high="Obese"

;

I am getting the following order even after I use order=formatted in the proc report

Normal

Obese

Overweight

Underweight.

Could anyone help please.

Thanks

[Tom]

That is the alphabetical order of the formatted values.  Did you try order=internal?

PS - What value should your format give for 18.495 ?  You should make the upper and lower limits of adjacent groups use the same value to prevent creating gaps.

[ballardw]

And use the < range modifier as appropriate on one end or the other.

[robertrao]

Hi Tom,

Unpectedly i deleted the answer. hope you get the credit for it anyways.

Thanks

[Tom]

You probably deleted your secondary post that I replied to and so that deleted everything related to it.

You should just re-post the solution you like and mark it as correct.  Don't worry about the points, it is showing an answer that is most valuable to future users that have a similar question.