The SAS Output Delivery System and reporting techniques

Same PROC REPORT ISSUE/PAGINATION(break)

Reply
Regular Contributor
Posts: 168

Same PROC REPORT ISSUE/PAGINATION(break)

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

   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

   pterms

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

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

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

(space)

ATCTERM3

   pterms

   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

SAS Super FREQ
Posts: 8,743

Same PROC REPORT ISSUE/PAGINATION(break)

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

Ask a Question
Discussion stats
  • 1 reply
  • 603 views
  • 0 likes
  • 2 in conversation