Using Across Variables

So far, we've looked at display, analysis, order, and group variables. You can also define variables as across variables, which are functionally similar to group variables. However, PROC REPORT displays the groups that it creates for an across variable horizontally rather than vertically.

Let's look at an example of across variables to clarify this usage.

Example

The following program uses group variables to produce the output shown. The table shows unique combinations of values of the group variables, and sums of each analysis variable for each combination.

     proc report data=flights.europe nowd headline headskip;
        where dest in ('LON','PAR');
        column flight dest mail freight revenue;
        define revenue / format=dollar15.2;
        define flight / group 'Flight/Number' width=6 center;
        define dest / group width=11 spacing=5
                      'Flight/Destination' center;
     run;

Now let's suppose that you change the group variables to across variables, as in this program.

     proc report data=flights.europe nowd headline headskip;
        where dest in ('LON','PAR');
        column flight dest mail freight revenue;
        define revenue / format=dollar15.2;
        define flight / across 'Flight/Number' width=6 center;
        define dest / across width=11 spacing=5
                      'Flight/Destination' center;
     run;