Proc report drop box

[Cristina_inet]

Good morning,
we are printing a pdf output with a table.
This table has the first cell empty.
We want to remove that empty cell.
How could we do it?

We generate it with proc report.

Thank you very much for everything.
Best wishes

[JosvanderVelden]

Please do not attach zip files to posts. Even simple .txt files can pose a security risk and therefore most attached files will NOT be opened by experienced security aware participants in this forum! You have the insert sas code option when you compose your post to insert code or log content. If your code/log seems too BIG for the insert sas code option then create an example that can be placed in the post using the insert code option. If you want to add an image/screenshot you can use the insert photo option. Thank you.

[Cynthia_sas]

Hi:

  As noted, it is unlikely that many people will open a zip file. Without seeing your code, it's hard to guess what you mean. There are 2 scenarios with PROC REPORT that come quickly  to mind, however, using Spanning Headers in a COLUMN statement or using ACROSS items. In either case, you see an empty cell sometimes, as shown below:

I don't know if this is what you're describing, but it is not possible in PROC REPORT syntax to "merge" the cells vertically in order to get rid of the empty cell above either Name (first example) or Region (second example).

You could fiddle around and change the border colors to try and make it appear as though there was just one cell -- it would still be 2 separate cells though. And depending on your destination, that may or may not work to fiddle with the border colors.

  You can do both row spanning and column spanning with the Report Writing Interface as shown in this paper https://support.sas.com/resources/papers/proceedings16/SAS5762-2016.pdf on page 19, you can see how vertical spanning is produced for the Overall CSS column. You'd have to use a similar technique if this is the type of thing you want to do.

  Cynthia