BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
SAS Super FREQ

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.

row_heights.png

 

 

cynthia

View solution in original post

2 REPLIES 2
ballardw
Super User

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?

Cynthia_sas
SAS Super FREQ

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.

row_heights.png

 

 

cynthia

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
  • 2 replies
  • 1415 views
  • 0 likes
  • 3 in conversation