topic How to insert an empty row in proc report in ODS and Base Reporting

How to insert an empty row in proc report

AKHILA — Tue, 30 Apr 2019 06:42:44 GMT

I have a dataset in which the first variable'name' like this ,say

Name
FRUIT
apple
Orange
Grapes
Mango
Cherry
FLOWER
Jasmine
Lilly
Lotus
COLOUR
blue
Pink
Yellow
red
How can i insert an empty row in proc report as i have splitted into different pages using pagebreak like:
Name
FRUIT
apple
Orange
Grapes
Mango
Cherry
----------------
FLOWER
Jasmine
Lilly
Lotus
---------------------
COLOUR
blue
Pink
Yellow
red

Re: How to insert an empty row in proc report

andreas_lds — Tue, 30 Apr 2019 07:05:10 GMT

The line-statement in a compute-block should do what you want.

Re: How to insert an empty row in proc report

Cynthia_sas — Tue, 30 Apr 2019 21:37:49 GMT

HI:
I'm not sure what you mean when you say "using pagebreak". Do you mean that the dashed line you show is actually where you want a page break? Or do you JUST want an empty line in the report before the strings COLOUR, FLOWER, FRUIT, etc??

While a compute block may help you, it will only work with GROUP or ORDER items on the report. So depending on what the rest of your data looks like, It seems to me like your data is using one column to hold grouping information and detail information, with no distinction between them.

If you could restructure your data, using PROC REPORT would be easier as shown below:

If you had something like a TYPE variable on every row, then you could control what was written out at the break.

Or, otherwise, restructure your data another way to get the same report:

My tendency is to prefer the first approach, but I have also used the second approach too.

Cynthia