topic Re: PROC REPORT sort by second column, then first column in SAS Procedures

PROC REPORT sort by second column, then first column

mariko5797 — Wed, 28 Jul 2021 19:53:41 GMT

I am new to using PROC REPORT and do not fully understand how the sorting works. My code is as follows (substituted with dummy variables):

proc report data = working nowd split = '*'
 %reportStyle;

 column VAR TIME _STAT_ CAT1 CAT2 CAT3;

 define VAR / order 'Variable' order = data style(column) = [just = left cellwidth = 0.7in];
 define TIME / order 'Subvariable' order = data style(column) =...;
 define _STAT_ / display 'Statistics' format = stat. style(column) = ...;
 define CAT1 / display 'CAT1' ...;
 define CAT2 / display 'CAT2' ...;
 define CAT3 / display 'CAT3' ...;

 compute after;
  line "Footnote";
 endcomp;
run;

I want it to first sort by Subvariable and then by Variable, while maintaining my desired order of columns.

Thank you in advance.

Re: PROC REPORT sort by second column, then first column

Tom — Wed, 28 Jul 2021 20:20:05 GMT

Introduce an extra copy of the second column as a hidden zero-th column to sort by.

proc report data=sashelp.class ;
  column sex=extra name sex age ;
  define extra / order noprint;
  define name / order ;
  define sex / order;
  define age / display;
run;

Re: PROC REPORT sort by second column, then first column

Cynthia_sas — Wed, 28 Jul 2021 20:30:36 GMT

Hi:
Without data, no one can run or tweak your code. When PROC REPORT does ordering, it orders the items from left to right (the same as PROC SORT). So when you list VAR first and then TIME, the result is that the report is ordered by TIME within VAR. If you want the order to be different you have to switch the order of VAR and TIME in the COLUMN statement so that TIME is first.
Cynthia