The SAS Output Delivery System and reporting techniques

display selected columns int the proc report

Reply
N/A
Posts: 0

display selected columns int the proc report

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.
Super Contributor
Posts: 260

Re: display selected columns int the proc report

Posted in reply to deleted_user
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
Ask a Question
Discussion stats
  • 1 reply
  • 109 views
  • 0 likes
  • 2 in conversation