how to apply labels while transposing in proc report by using across option

[thanikondharish]

data rawdata ;

input id $ test $ result ;

cards;

101 bp 120

101 wbc 230

101 rbc 234

102 bp 120

102 wbc 230

102 rbc 234

run;

Note: we need to transpose the data in proc report only

ods rtf file="path" ;

proc report data=rawdata ;

column id test result ;

define test/across ;

define id/order ;

run;

ods rtf close ; 

output should be like:

                  Analysis Variables

           ----------------------------------
id         bp           wbc            rbc   

101    120          230           234

102    120          230           234

my question is how to apply extra label for all  test varibles "Analysis Variables"  while transposing 
Note: We should do in proc report only (don't use proc tranpose)

[PaigeMiller]

define test/across "Analysis Variables";

[thanikondharish]

Below label we need to get one underline

[PaigeMiller]

https://communities.sas.com/t5/SAS-Programming/Creating-Spanning-header-Underline-in-proc-report-rtf...

[Ksharp]

data rawdata ;
input id $ test $ result ;
cards;
101 bp 120
101 wbc 230
101 rbc 234
102 bp 120
102 wbc 230
102 rbc 234
;
run;





ods rtf file="c:\temp\temp.rtf" style=journal bodytitle;
ods escapechar = '^';
proc report data=rawdata split='*'  nowd;
column id result,test ;
define test/across "^R/RTF'\brdrb\brdrs 'Analysis Variables";
define result/analysis ' ';
define id/group ;
run;
ods rtf close ; 

[Cynthia_sas]

Hi:

  As an alternative, this is also possible with a style override instead of RTF control strings. This means the technique would work in other destinations, not just RTF:

Cynthia

[thanikondharish]

how to apply label for only 2 columns like :
                                Analysis Variable

                              ----------------------------

id        bp                 rbc              rbc

101    120              230              340

[Ksharp]

Then , You should use proc tranpose .