topic Re: Proc report-formatting in Statistical Procedures

Proc report-formatting

robertrao — Mon, 17 Sep 2012 17:15:40 GMT

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

Re: Proc report-formatting

Tom — Mon, 17 Sep 2012 17:39:01 GMT

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.

Re: Proc report-formatting

ballardw — Mon, 17 Sep 2012 17:50:45 GMT

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

Re: Proc report-formatting

robertrao — Mon, 17 Sep 2012 21:04:59 GMT

Hi Tom,

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

Thanks

Re: Proc report-formatting

Tom — Mon, 17 Sep 2012 21:36:44 GMT

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.