topic Stored Process - xlsx - text header 90 degrees in ODS and Base Reporting

Stored Process - xlsx - text header 90 degrees

cuevasj — Tue, 19 Jun 2018 15:43:11 GMT

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;

Re: Stored Process - xlsx - text header 90 degrees

DJongman — Fri, 29 Jun 2018 08:34:22 GMT

Try using the next line:

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

This should turn all headers.

Re: Stored Process - xlsx - text header 90 degrees

cuevasj — Mon, 09 Jul 2018 14:00:16 GMT

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

Re: Stored Process - xlsx - text header 90 degrees

Cynthia_sas — Mon, 09 Jul 2018 17:38:04 GMT

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

Re: Stored Process - xlsx - text header 90 degrees

DJongman — Tue, 10 Jul 2018 05:39:33 GMT

Hi Cuevasj,

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

A little codeline to get you started.

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