topic Re: proc tabulate class by ascending order in New SAS User

proc tabulate class by ascending order

msrenee1984 — Mon, 29 Nov 2021 19:39:04 GMT

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?

Re: proc tabulate class by ascending order

Reeza — Mon, 29 Nov 2021 20:07:30 GMT

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.

Re: proc tabulate class by ascending order

msrenee1984 — Mon, 29 Nov 2021 20:17:49 GMT

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? ?

Re: proc tabulate class by ascending order

Reeza — Mon, 29 Nov 2021 20:19:55 GMT

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.

Re: proc tabulate class by ascending order

msrenee1984 — Mon, 29 Nov 2021 20:31:47 GMT

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

Re: proc tabulate class by ascending order

msrenee1984 — Mon, 29 Nov 2021 20:40:14 GMT

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

thanks