display selected columns int the proc report

[deleted_user]

A B C
Xx x1 4
Xx x2 5
Yy x1 3
Yy x2 5
Yy x3 7
Yy x4 6
I have above data, what I want is to create a report like
XX YY
x1 x2 x1 x2 x3 x4
4 5 3 5 7 6
I am using the variables A and B as analysis variables in proc report. But giving an output as below
XX YY
x1 x2 x3 x4 x1 x2 x3 x4
But I don’t want the columns x3, x4 to be displayed under XX.
Please help me in getting the above output
if it is not possible with proc report then please suggest me alternatives.

[Olivier]

Hi.
Maybe you can give the NOCOMPLETEROWS option a try. It asks Report to display columns corresponding to real combinations seen in the dataset.
Otherwise you can use the Tabulate procedure.
[pre]
DATA work.test ;
INPUT A $ B $ C ;
CARDS ;
Xx x1 4
Xx x2 5
Yy x1 3
Yy x2 5
Yy x3 7
Yy x4 6
;
RUN ;
PROC REPORT DATA = work.test NOWD NOCOMPLETECOLS ;
COLUMNS a,(b,c) ;
DEFINE a / ACROSS ;
DEFINE b / ACROSS ;
DEFINE c / MEAN FORMAT=8. ;
RUN ;
PROC TABULATE DATA = work.test F=8. ;
CLASS a b ;
VAR c ;
TABLE a="" * b="" * c="" * MEAN="" ;
RUN ;
[/pre]
Regards,
Olivier