The SAS Output Delivery System and reporting techniques

gray space at top of excel spreadsheet

Reply
Contributor
Posts: 61

gray space at top of excel spreadsheet

I am using Base SAS for Windows version 9.2, (TS Level 2M3) on a Windows XP Professional platform.  I am just becoming familiar with using ODS Tagsets.ExcelXP with PROC REPORT and TAGATTR=.   My spreadsheet generates the columns in the proper format and font and color, but there are about three blank lines at top of the spreadsheet, just above the first Title in the report.  These blank lines are shaded in gray tint, while the rest of the report from the titles down thru headers and the data and footnotes, all have white background.

How do I get rid of the gray shading at the top?

SAS Super FREQ
Posts: 8,868

Re: gray space at top of excel spreadsheet

Hi:

  It could be the procedure you are using. It could be the EXCELXP options you are using. It could be the style you are using. Without seeing your code it's hard to make a constructive suggestion.

  If you change the style to STYLE=SASWEB or STYLE=MINIMAL or STYLE=HTMLBLUE, do you still get the gray area? What are your ExcelXP suboptions? Do you have embedded_titles='on'? Do you have ODS TEXT= statements before your first title statement? Do you have anythings else going on in the code? Did you make a custom style or are you trying to use a custom style? If you look at my screenshot (SAS 9.3 and Excel 2010), I do not have a gray area above my titles.

  If you try my code (shown in the screenshot) in SAS 9.2 and get gray above your titles, then you might want to open a track with Tech Support. I am pretty sure the code I posted would work the same way in SAS 9.2 (I just don't have 9.2 to test with or Windows XP either.)

cynthia


nogray_in_excel.png
Ask a Question
Discussion stats
  • 1 reply
  • 592 views
  • 0 likes
  • 2 in conversation