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
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: