The SAS Output Delivery System and reporting techniques

Stored Process - xlsx - text header 90 degrees

Accepted Solution Solved
Reply
Contributor
Posts: 33
Accepted Solution

Stored Process - xlsx - text header 90 degrees

I have a stored process that is accessed via VA. Some of the column headers are lengthy, and I would like to rotate the text on those headers only 90° ? The stored process is using proc report to do all the excel formatting.

 


proc report data=details missing nowd split='~'
style(header)={just=c font_face=Calibri font_size=11pt font_weight=bold color=BLACK background=PKGR};
columns (('School~Year' doe_year)('Student Name' student_name)('Student~ID' dcps_student_id)

('1718 Integration of~Knowledge & Ideas' PY_RO_Intgrtn_Knwldge_Ideas)
('1718 Language/Editing~Task' PY_RO_Lngge_Edtng_Tsk)
('1718 Craft~& Structure' PY_RO_Crft_Strctre)
('1718 Key Ideas~& Details' PY_RO_Ky_Ids_Dtls)
('1718 Test-Based~Writing' PY_RO_Txt_Bsd)

);

define doe_year / display style={just=c font_face=Calibri font_size=11pt width=2.0cm}'';
define student_name / display style={just=l font_face=Calibri font_size=11pt width=6.0cm}'';
define dcps_student_id / display style={just=c font_face=Calibri font_size=11pt width=3.0cm}'';

define PY_RO_Intgrtn_Knwldge_Ideas / display style={just=c font_face=Calibri font_size=11pt width=1.0cm}'';
define PY_RO_Lngge_Edtng_Tsk / display style={just=c font_face=Calibri font_size=11pt width=1.0cm}'';
define PY_RO_Crft_Strctre / display style={just=c font_face=Calibri font_size=11pt width=1.0cm}'';
define PY_RO_Ky_Ids_Dtls / display style={just=c font_face=Calibri font_size=11pt width=1.0cm}'';
define PY_RO_Txt_Bsd / display style={just=c font_face=Calibri font_size=11pt width=1.0cm}'';


compute doe_year;
count+1;
if (mod(count,2)) then do;
call define(_row_,'style','style=[background=#EEE8DC]');
end;
endcomp;

run;


Accepted Solutions
Solution
‎07-11-2018 01:38 PM
Occasional Contributor
Posts: 11

Re: Stored Process - xlsx - text header 90 degrees

[ Edited ]

Hi Cuevasj,

 

 As has written, you can set it for one designated column.

 

define columnname / style(header)=[tagattr='rotate:90'];

 

View solution in original post


All Replies
Occasional Contributor
Posts: 11

Re: Stored Process - xlsx - text header 90 degrees

[ Edited ]

Try using the next line:

 

define _ALL_ / style (header)={tagattr='rotate:90' font_size=11pt vjust=t just=left};

This should turn all headers.

Contributor
Posts: 33

Re: Stored Process - xlsx - text header 90 degrees

What if I only want to rotate some columns, but not others? Is this an all or nothing deal?


SAS Super FREQ
Posts: 9,431

Re: Stored Process - xlsx - text header 90 degrees

Hi, instead of using define _all_, you would add the style override only to the define statements where you want to rotate the header.
cynthia

Solution
‎07-11-2018 01:38 PM
Occasional Contributor
Posts: 11

Re: Stored Process - xlsx - text header 90 degrees

[ Edited ]

Hi Cuevasj,

 

 As has written, you can set it for one designated column.

 

define columnname / style(header)=[tagattr='rotate:90'];

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 244 views
  • 0 likes
  • 3 in conversation