you should be able to get what you want, see example below.
Some remarks:
All the "grouping/ordering" columns have the GROUP usage, order implies that you see all the detail records
We do need the _DUMMY variable, otherwise we get an error
Have a go.
data have;
infile cards dlm="," dsd;
input
seqnr : 8.
texto : $32.
alg : 8.
x0 : $16.
x1 : $16.
;
cards;
2,line1,1,1(1),1(1)
2,line1,2,1(2),1(2)
1,line2,1,10(abc),10(20)
1,line2,2,10(hello),10
3,,1,,
4,line4,1,4(1),40(1)
4,line4,2,4(2),40(2)
;
proc report data=have missing;
column
seqnr
texto alg, (x0 x1)
_dummy
;
;
define seqnr / group;
define texto / group;
define alg / across;
define x0 / display;
define x1 / display;
define _dummy / computed noprint;
run;
... View more
