There are too many steps, I believe there is simple way. proc sort data=sashelp.class out=temp;
by name;
run;
proc transpose data=temp out=temp1;
by name;
var name--age;
run;
data want;
set temp1;
if mod(_n_,3)=1 then k+1;
flag=k;
Name=cats(_name_,':');
keep flag name col1;
run;
proc report data=want(obs=3) nowd headskip headline noheader;
define flag/order noprint;
break after flag/page;
run
... View more
