BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
cuevasj
Quartz | Level 8

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;

1 ACCEPTED SOLUTION

Accepted Solutions
DJongman
Obsidian | Level 7

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

4 REPLIES 4
DJongman
Obsidian | Level 7

Try using the next line:

 

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

This should turn all headers.

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


Cynthia_sas
SAS Super FREQ

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

DJongman
Obsidian | Level 7

Hi Cuevasj,

 

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

 

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

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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