BookmarkSubscribeRSS Feed
PaigeMiller
Diamond | Level 26

I am having a small problem with ODS EXCEL (yes, I know it is experimental), where parts of the letters in the first row are cut off, and I can't find an option in either ODS EXCEL or PROC REPORT to modify this behavior. Attached is a screen capture, note that in columns D, E and H, the tops of the letters are cut off. Since these reports go to engineers and managers, I'd like to fix it before a manager stops by my office and tells me to fix it. Any ideas?


Binary_AA045_WFR_limyield.jpg
--
Paige Miller
12 REPLIES 12
Reeza
Super User

Are you manually setting the row height?

PaigeMiller
Diamond | Level 26

No, I am not because unlike ODS TAGSETS.EXCELXP, the row height option is disabled and does nothing in ODS EXCEL. Although there appears to be a new option ABSOLUTE_ROW_HEIGHT, this isn't what I want, as it sets every row height to the same value. I was under the impression that the proper setting of Row Heights would happen automatically, but either I am mistaken or it isn't working, which is why I would like to set the height of row 1 myself, if only I could find out how.

--
Paige Miller
Steelers_In_DC
Barite | Level 11

I'm not able to test this right now but see if this works in your options line:

autofit_height = 'yes'

PaigeMiller
Diamond | Level 26

That command doesn't apply to ODS EXCEL, according to http://support.sas.com/resources/papers/proceedings14/SAS177-2014.pdf, which implies that there's no need for such a command as Excel handles this properly.

--
Paige Miller
Ksharp
Super User

What proc are you using to create EXCEL file ?

proc report ?

Could change cell height in proc report via STYLE ?

proc report   style(header)={ cellheight=20cm }   ?

Xia Keshan

PaigeMiller
Diamond | Level 26

Yes, I am using PROC REPORT.

Your answer helps in the sense that I can specify a cellheight and the problem goes away, as long as the text doesn't need a bigger cell height — and since I'm working with text that can change dynamically, it would still be better if the height of the cell was fit automatically to the amount of text present, which is what I really want, and which is what I thought ODS EXCEL would provide.

So thank you for this answer.

Nevertheless, , I have a related question.

In SAS, I press F1 and call up the SAS Help and Documentation, and then do a search for cellheight. Guess what, the search fails to find any reference to cellheight, so where is the documentation on cellheight? What other style elements are available that don't appear in SAS help? Who can point me to a full list of possible style elements I can use with PROC REPORT?

--
Paige Miller
Ksharp
Super User

HoHo,  Cynthia is here and She is good at it .

Message was edited by: xia keshan

Ksharp
Super User

A workaround I can think is padding a blank character like '09'x  before the label of variables .

And also try this style:

proc report   style(header)={ cellpadding=100 }




Xia Keshan

PaigeMiller
Diamond | Level 26

Cellpadding seems to have no effect on the first row (headers), which is also what I understand from the appropriate parts of SAS Help

Base SAS(R) 9.4 Procedures Guide, Third Edition

--
Paige Miller
Ksharp
Super User

Try to put it on a variable .

define x/.....  style={ cellpadding=100cm }

Cynthia_sas
SAS Super FREQ

Hi:

  Putting cellpadding on a DEFINE statement for a particular variable or item will not work. CELLPADDING is a table-level change. You can test this out for yourself by running the code below. See attached output. Only #2 changes the padding inside each table cell. Code for #3 and #4 have no impact on PROC REPORT output.

Cynthia

cp.png

ods html file='cellpadding.html';

proc report data=sashelp.class(obs=2) nowd;
  title '1 cellpadding default';
run;

 

proc report data=sashelp.class(obs=2) nowd
  style(report)={cellpadding=10px};
  title '2 cellpadding change for table';
run;

 

proc report data=sashelp.class(obs=2) nowd
  style(header)={cellpadding=10px};
  title '3 try cellpadding on header';
run;

 

proc report data=sashelp.class(obs=2) nowd;
  title '4 try cellpadding on column';
  define name / style(column)={cellpadding=10px};
run;
ods _all_ close;

PaigeMiller
Diamond | Level 26

An e-mail from SAS tech support indicates this is a bug that will be fixed when ODS EXCEL is made production (right now it is experimental)

--
Paige Miller

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
  • 12 replies
  • 3315 views
  • 6 likes
  • 5 in conversation