Same PROC REPORT ISSUE/PAGINATION(break)

sam369 — Mon, 09 Jan 2012 04:04:20 GMT

This is about same same issuew of proc report. I am copying my question again in this post. This time i attached the shell too. All i need is The FINAL RTF is getting exactly what i shell mentioned but only issue is pagination. IF pterm come under next page... i need to show..... SOC(Continuned) on that page ...

ATCTERM/PTERMS trt1 trt2 total

Subjects with >=1 Concomitant Med 100 ( 99.6) 900 ( 98.8) 1000 ( 99.2)

3-OXOANDROSTEN (4) DERIVATIVES 8 ( 0.8) 1 ( 0.2) 9 ( 0.5) TESTOSTERONE 4 ( 0.8) 7 ( 0.2) 5 ( 0.5)

ACE INHIBITORS AND CALCIUM CHANNEL BLOCKERS 7( 1.2) 2 ( 0.4) 9 ( 0.8)

AMLODIPINE BESYLATE W/BENAZEPRIL HYDROCHLOR. 9 ( 1.2) 2 ( 0.4) 8 ( 0.8)

ACE INHIBITORS AND DIURETICS 63( 1.2) 0 ( 0.0) 63 ( 0.6)

BI PREDONIUM 2 7( 0.4) 0 ( 0.0) 2 ( 0.2)

CIBADREX 10( 0.2) 0 ( 0.0) 1 ( 0.1)

SALUTEC 14 ( 0.2) 0 ( 0.0) 1 ( 0.1)

ZESTORETIC 2 ( 0.4) 0 ( 0.0) 2 ( 0.2)

ACE INHIBITORS, PLAIN 104 ( 20.6) 115 ( 22.7) 219 ( 21.6)

BENAZEPRIL 8 ( 1.6) 6 ( 1.2) 14 ( 1.4)

CAPTOPRIL 5 ( 1.0) 2 ( 0.4) 7 ( 0.7)

CILAZAPRIL 1 ( 0.2) 0 ( 0.0) 1 ( 0.1)

ENALAPRIL 20 ( 4.0) 32 ( 6.3) 52 ( 5.1)

Suppose if it breaks after at this place in need in next page like

ACE INHIBITORS, PLAIN (cont)

FOSINOPRIL 1 ( 0.2) 2 ( 0.4) 3 ( 0.3)

IMIDAPRIL 1 ( 0.2) 0 ( 0.0) 1 ( 0.1)

LISINOPRIL 49 ( 9.7) 52 ( 10.3) 101 ( 10.0)

PERINDOPRIL 3 ( 0.6) 3 ( 0.6) 6 ( 0.6)

QUINAPRIL 0 ( 0.0) 5 ( 1.0) 5 ( 0.5)

ADRENERGICS AND OTHER DRUGS FOR OBSTRUCTIVE AIRWAY 10 ( 2.0) 14 ( 2.8) 24 ( 2.4)

BUDESONIDE W/FORMOTEROL FUMARATE 1 ( 0.2) 1 ( 0.2) 2 ( 0.2)

COMBIVENT 1 ( 0.2) 2 ( 0.4) 3 ( 0.3)

FORMOTEROL W/BUDESONIDE 1 ( 0.2) 0 ( 0.0) 1 ( 0.1)

SERETIDE 8 ( 1.6) 12 ( 2.4) 20 ( 2.0) .

This is the table RTF i was highlited "ACE INHIBITORS, PLAIN (cont)"

term trt1 trt2 total

atcterm1

pterms

.........

........

...........

.............

..........

pterms so on

(space)

atcterm2

pterms

-----------

------------

-----------------

---------------

-----------------

---------------

----------------

(if page break was here then i need to show the ATCTERM on next page like atcterm+(cont) ACE INHIBITORS, PLAIN (cont)

On Next page

ATCTERM2 (cont)

pterms

------------------

----------------

---------------

(space)

ATCTERM3

pterms

--------------

-------------

like so on

I am getting everthing right(correct) in final RTF the breaks and space every thing as i shownws in above final RTF. The only thing is not getting is, if pterm is break at the end of the page and continued in next page i need to show an extra line with ATCTERM2 (cont) in required pages

Thanks in advance

Sam

Same PROC REPORT ISSUE/PAGINATION(break)

Cynthia_sas — Mon, 09 Jan 2012 06:13:36 GMT

Hi:

Your image seems to be an image of the desired report -- shown as a sort of "shell" report. This is not as useful as seeing your actual PROC REPORT code or seeing your actual RTF report, as it looks in Microsoft Word...pasting the text into the forum posting isn't quite as useful as seeing a real picture of the actual output results because of the narrowness of the forum area for the post. But at this point, your description of WHAT you want to do is clear, continuing to post your output is not helpful. However, without input data or actual code, it would be hard for someone to code a COMPUTE block that might or might not work, because the solution is dependent on your input data and how your PROC REPORT is coded.

Did you look at any of the previously posted links? Are you using a COMPUTE block? Did you even try a COMPUTE block? Did you make a fake or custom page break variable to use on the report? Are you using ODS TAGSETS.RTF or just ODS RTF? Did you use SPANROWS and/or UNIFORM? What you are describing right now sounds like the default PROC REPORT behavior. If you do not like the default behavior, usually, you have to try some of the techniques shown in the posted links -- usually this means making a fake or custom page breaking variable. You need to do this so you can take control of the page breaks instead of letting PROC REPORT perform page breaking.

Your best bet for help at this point would be to work with Tech Support. They can look at ALL of your data and ALL of your PROC REPORT code to give you the best advice.

cynthia

topic Same PROC REPORT ISSUE/PAGINATION(break) in ODS and Base Reporting

Same PROC REPORT ISSUE/PAGINATION(break)

Same PROC REPORT ISSUE/PAGINATION(break)