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'];
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.