Any idea as to why my first row is getting cuttoff?
Please embed the image into your post using the photo option. Many uses will not download a zip file.
Thank you for the idea, please see the picture below!
Is that image from an Excel document by chance? I've seen such things when a row height is too short for the displayed text size.
If so something may have accidentally changed the row height or some instruction in the proc report code may be doing something to the height.
Can you share the code used to generate that table?
Hi Cynthia,
Here is all of my code:
title1 font = 'Times New Roman' height = 12pt justify = center underlin = 0 color = blue bcolor = white 'Attachment I';
title2 font = 'Times New Roman' height = 12pt justify = center underlin = 0 color = black bcolor = white 'Response';
proc report data = attach1 nowindows headline headskip missing center
style(report)=[cellspacing=2 borderwidth=2 bordercolor=black]
style(header) = {font_weight = light font_face = 'Times New Roman' font_size = 8pt just = center cellheight=.22in }
style(column) = {font_face = 'Times New Roman' font_size = 8pt just = center /*asis = on*/ cellheight=.15in};
column
('^S={borderleftcolor=black borderleftwidth=3} '('^S={borderrightcolor=black borderrightwidth=3 borderleftcolor=black borderleftwidth=3 borderbottomcolor=black borderbottomwidth=3}Sample' case ))
('^S={borderleftcolor=black borderleftwidth=3 borderrightcolor=black borderrightwidth=3 borderbottomcolor=black borderbottomwidth=3}Response'
('^S={borderleftcolor=black borderleftwidth=3 borderbottomcolor=black borderbottomwidth=3}Panel 1' resp1)
('^S={borderbottomcolor=black borderbottomwidth=3}Panel 2' resp2)
('^S={borderbottomcolor=black borderbottomwidth=3}Panel 3' resp3) )
('^S={borderleftcolor=black borderleftwidth=3} '('^S={borderleftcolor=black borderleftwidth=3 borderbottomcolor=black borderbottomwidth=3}Mean' mean )) ('^S={borderrightcolor=black borderrightwidth=3} '('^S={borderrightcolor=black borderrightwidth=3 borderbottomcolor=black borderbottomwidth=3}%CV' cv )) ;
define case / display ' ' center style=[cellwidth=16mm] ;
define resp1 / display ' ' center style=[cellwidth=16mm];
define resp2 / display ' ' center style=[cellwidth=16mm];
define resp3 / display ' ' center style=[cellwidth=16mm] flow ;
define mean / display format = 12.1 ' ' center style=[cellwidth=16mm];
define cv / display format = percent8.1 ' ' center style=[cellwidth=16mm] ;
compute case;
if case <1000 then call define(_col_,"style","style={borderrightcolor=black borderrightwidth=3 borderleftcolor=black borderleftwidth=3}");
endcomp;
compute mean;
if mean <5000000 then call define(_col_,"style","style={borderleftcolor=black borderleftwidth=3}");
endcomp;
compute cv;
if cv <5000000 then call define(_col_,"style","style={borderrightcolor=black borderrightwidth=3}");
endcomp;
run;
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.