My CSS file looks like this
tbody tr { height: 25px; }
My SAS code looks like
ods excel file=test.xlsx cssstyle=&cssstyle;
proc print data=foo noobs;
run;
ods excel close;
It doesn't seem to have any effect on row heights.
Hi:
I can't remember if ODS EXCEL uses CSSSTYLE option. That is a question for Tech Support and they will want to see the whole CSS file.
But within ODS EXCEL, you can use the ROW_HEIGHTS sub-option to alter the row heights. It is in the doc. For example, here, I made only the headers taller.
cynthia
What is the value of the macro variable &cssstyle?
PX may be a less than ideal unit of measure as PX is dependent on screen resolution and the file created likely wouldn't know the screen resolution. Have you tried setting an measure such as IN or CM for constant height or PCT if you need some that changes per screen size or resolution?
Hi:
I can't remember if ODS EXCEL uses CSSSTYLE option. That is a question for Tech Support and they will want to see the whole CSS file.
But within ODS EXCEL, you can use the ROW_HEIGHTS sub-option to alter the row heights. It is in the doc. For example, here, I made only the headers taller.
cynthia
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.