topic Re: ods excel: "dynamic" row heights? in ODS and Base Reporting

ods excel: "dynamic" row heights?

sworobec1 — Wed, 22 Jul 2020 04:27:18 GMT

Hello All,

I'm using the below program to output to excel. I'm getting a lot of rows that are too high. I suspect this is because SAS is looking at the row that's the highest (there's one that has a lot more text in one column than the others) and setting all row heights to match it. How do I make it so the heights are dynamic for each row?

ODS LISTING CLOSE;

ods excel file="folder\test.xlsx"

style=htmlblue;

ods excel options(

flow='tables'

sheet_name ='test'

embedded_titles='yes'

sheet_interval="none"

orientation='landscape');

Title 'a title';

run;

PROC PRINT DATA= test noobs;

RUN;

ODS _ALL_ CLOSE;

Re: ods excel: "dynamic" row heights?

Cynthia_sas — Wed, 22 Jul 2020 14:16:02 GMT

Hi:
Without some test data, nobody can run your program. Can you mock up an example using SASHELP.CLASS that shows the behavior you describe?
Cynthia

Re: ods excel: "dynamic" row heights?

RichardDeVen — Tue, 04 Aug 2020 03:37:34 GMT

This code does not demonstrate 'all rows too tall', only the row with long text 'wrapped'.

data cars;
  retain make model;
  length model $500;
  set sashelp.cars(obs=10);
  if _n_ = 7 then model = repeat(trim(model),25);
run;

ODS _ALL_ CLOSE;

ods excel file="test.xlsx" style=htmlblue
  options(
    flow = 'tables'
    sheet_name = 'test'
    embedded_titles = 'yes'
    sheet_interval = "none"
    orientation = 'landscape'
  );

PROC PRINT DATA=cars noobs;
  Title '10 of the Cars data';
RUN;

ODS _ALL_ CLOSE;

You might have data with leading spaces, hard spaces (A0x), or semi-long data that is not being measured and layed out by ODS EXCEL according to 'human-eye' 'font-point' expectations.