topic PROC TABULATE ORDER=FREQ only for rows in SAS Procedures

PROC TABULATE ORDER=FREQ only for rows

hellind — Thu, 04 Aug 2011 06:46:02 GMT


proc tabulate data=CA_NON_REFER  ORDER=FREQ;
class application_month CHECKLIST_FAIL;
table CHECKLIST_FAIL * (N COLPCTN) , application_month  ;
run;

Hi,

This is a cross tabulation simplified version of my code; of the number of application coming in each month, what is the top checklists that fail.

Application Month on the Y-axis, Checklist on the X-axis.

I use ORDER=FREQ to sort by frequency, and it is working on the y-axis checklists. But I don't want the x-axis application month to be sorted by frequency.

Besides workarounds, is there a build-in function in proc-tabulate for sorting frequency only for rows?

PROC TABULATE ORDER=FREQ only for rows

Ksharp — Thu, 04 Aug 2011 10:34:20 GMT

Could you make a format then using this format to customize the order.

class ../preloadfmt order=formate/data?

Ksharp

PROC TABULATE ORDER=FREQ only for rows

data_null__ — Thu, 04 Aug 2011 11:46:02 GMT

Remove the ORDER= option from the PROC statement and move it to the CLASS statement to which it applies.

proc tabulate data=sashelp.class;

class sex;

class age / order=freq;

tables age,sex;

run;

PROC TABULATE ORDER=FREQ only for rows

hellind — Fri, 05 Aug 2011 04:22:37 GMT

Thank you both for helping.

proc tabulate data=CA_NON_REFER ; class application_month;

class CHECKLIST_FAIL /ORDER=FREQ; table CHECKLIST_FAIL * (N COLPCTN) , application_month ; run;