How to merge multiple cells in proc report?and How to reduce row height ?

[MSK4]

Here is the image. 

Arrow 1 represent how to reduce row height by using proc report?

Arrow 2 represent how merge three cells and get grand total in merged cell?

Please help me . Thanks in advance.

[Kurt_Bremser]

---

@MSK4 wrote:

Here is the image. 

Arrow 1 represent how to reduce row height by using proc report?

Arrow 2 represent how merge three cells and get grand total in merged cell?

Please help me . Thanks in advance.

---

I see no arrow in your picture. Please post example data in usable form (data step with datalines), and a screenshot of the intended report, as you create it manually in Excel.

[ballardw]

"Merged cell" would typically mean only show one cell with the contents of multiple variables.

Which I would take means the data is structured incorrectly for normal SAS usage.

If you mean that want to add a column that is the SUM of variables of A1, A2 and A3 say so as that is not a "merge"

Example values, example desired output and code you are currently using is pretty much neede

[MSK4]

"Merged cell" would means only show one cell with the content of Grand total. Please check picture above thank you.

[PeterClemmensen]

Show us your data please.

[ballardw]

---

@MSK4 wrote:
"Merged cell" would means only show one cell with the content of Grand total. Please check picture above thank you.

---

Sorry but your picture is not exactly helpful without values in cells. All of the "totals" would be blank, so no reason to show a column at all.

Show the basic report code you are using to get a far as you have so far. And example data is really helpful.