Programming the statistical procedures from SAS

Proc report-formatting

Reply
Super Contributor
Posts: 1,040

Proc report-formatting

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

Super User
Super User
Posts: 6,144

Re: Proc report-formatting

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.

Grand Advisor
Posts: 10,052

Re: Proc report-formatting

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

Super Contributor
Posts: 1,040

Re: Proc report-formatting

Hi Tom,

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

Thanks

Super User
Super User
Posts: 6,144

Re: Proc report-formatting

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.

Ask a Question
Discussion stats
  • 4 replies
  • 215 views
  • 0 likes
  • 3 in conversation