display selected columns int the proc report

deleted_user — Mon, 28 Jul 2008 09:36:53 GMT

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.

Re: display selected columns int the proc report

Olivier — Mon, 28 Jul 2008 12:14:20 GMT

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

topic Re: display selected columns int the proc report in ODS and Base Reporting

display selected columns int the proc report

Re: display selected columns int the proc report