proc tabulate class by ascending order

[msrenee1984]

proc tabulate data=R.THEOFFSITEWORK order=data;
class CDPRMASS *THEFACILITY/ASCENDING;
tables THEFACILITY *CDPRMASS/rts=25.row=float;
keylabel n=' ';
run;

I need "THEFACILITY" data to output in ascending order ?? its not working...it should be New Hanover then Orange, then Wake?

[Reeza]

Are you referring to order of the data in the cells? Order controls it by the CLASS variable, not the summarized data, eg. name of the facility in alphabetical ascending/descending.

If you specify order=FREQ then it will sort by frequency which is what I think you want.

[msrenee1984]

Correct, I just want the facility names to be in order not too concerned with the actual data within each cell. My output has about 70 facility names (new hanover, orange, wake, johnson etc.. and the requester said she needs them in order.  So should I put the order statement in place of the ascending command? ?

[Reeza]

proc tabulate data=R.THEOFFSITEWORK order=freq;
class CDPRMASS *THEFACILITY;
tables THEFACILITY *CDPRMASS/rts=25.row=float;
keylabel n=' ';
run;

I would try this, but not 100% sure what you want is actually possible.

[msrenee1984]

So far no luck but thank you very much for assisting.  I' think you're right maybe its not possible...I figured ascending would do the trick.  I'll have to sort each manually in excel 

[msrenee1984 · Accepted solution]

Solved: I removed  "rts=25.row=float", every facility is in alphabetical order now.  Whew!!

thanks