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

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

thanikondharish — Sat, 23 Apr 2022 06:15:30 GMT

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)

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

PaigeMiller — Sat, 23 Apr 2022 09:44:26 GMT

define test/across "Analysis Variables";

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

thanikondharish — Sat, 23 Apr 2022 09:50:24 GMT

Below label we need to get one underline

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

PaigeMiller — Sat, 23 Apr 2022 10:10:54 GMT

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

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

Ksharp — Sat, 23 Apr 2022 10:57:05 GMT

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 ;

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

Cynthia_sas — Sat, 23 Apr 2022 15:39:25 GMT

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

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

thanikondharish — Mon, 25 Apr 2022 05:31:16 GMT

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

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

id bp rbc rbc

101 120 230 340

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

Ksharp — Mon, 25 Apr 2022 10:25:46 GMT

Then , You should use proc tranpose .