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;
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.