Hi, Can someone please help me add in code, so that the proc freq table lists the different bands I have created in order, rather than it being sorted in numerical order i.e. when I run my code, the '10,000 < NUMBER <= 20,000' results are before the row of results before '2,000 < NUMBER <= 4,000'. Would it be possible so that the proq freq lists bands in the order I want (i.e code that could be added to the proc freq statement)?: Current code produces proc freq table that is sorted in numerical band order PROC FREQ TABLE order from code written: '0 <= NUMBER <= 2,000' '10,000 < NUMBER <= 20,000' '2,000 < NUMBER <= 4,000'' '4,000 < NUMBER <= 6,000' '6,000 < NUMBER <= 8,000' '8,000 < NUMBER <= 10,000' proc freq order required (in the order that I have listed in my code) '0 <= NUMBER <= 2,000' '2,000 < NUMBER <= 4,000' '4,000 < NUMBER <= 6,000' '6,000 < NUMBER <= 8,000' '8,000 < NUMBER <= 10,000' '10,000 < NUMBER <= 20,000' Code data test; set ac.number_values; length BAND $25; if 0 <= NUMBER <= 2000 then PD_C_12_BAND = '0 <= NUMBER <= 2,000'; else if 2000 < NUMBER <= 4000 then BAND = '2,000 < NUMBER <= 4,000''; else if 4000 < NUMBER <= 6000 then BAND = '4,000 < NUMBER <= 6,000'; else if 6000 < NUMBER <= 8000 then BAND = '6,000 < NUMBER <= 8,000'; else if 8000 < NUMBER <= 10000 then BAND = '8,000 < NUMBER <= 10,000'; else BAND = '10,000 < NUMBER <= 20,000'; run; proc freq data = test; tables BAND; run;
... View more