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;
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'];
Try using the next line:
define _ALL_ / style (header)={tagattr='rotate:90' font_size=11pt vjust=t just=left};
This should turn all headers.
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
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'];
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.