The SAS Output Delivery System and reporting techniques

In Proc report define page option results in page crop

Reply
N/A
Posts: 1

In Proc report define page option results in page crop

I am using ODS RTF output.

I have a couple of columns with parameters (VISIT, PARAM name) and multiple columns with counts.

In order to separate columns I use PAGE option in define statement.

   proc report data=DATASET nowindows contents="" split='|' missing;
      by page1;
      columns page1 AVISITN AVISIT COMP blank STAT c1 c2 c3 c4 c5 c6 c7;

      define page1     /  id order noprint;
      define AVISITN /  id group order=data noprint;
      define AVISIT  /  id group order=data "Visit"  style={just=l cellwidth=9% asis=on };
      define COMP/  id order=data "Parameter"   style={just=l cellwidth=40% asis=on };
      define blank  /  id order=data " " style={just=l cellwidth=1% asis=on };
      define STAT  /  id order=data "Statistic"   style={just=l cellwidth=9% asis=on };

      define c1      / "100 mg|(N=&var_patnum1.)"    style={just=l cellwidth=8% asis=on };

      define c2      / "200 mg|(N=&var_patnum2.)"    style={just=l cellwidth=8% asis=on };

      define c3      / "300 mg|(N=&var_patnum3.)"    style={just=l cellwidth=8% asis=on };

      define c4      / "400 mg|(N=&var_patnum4.)"    style={just=l cellwidth=8% asis=on };

      define c5      /page "800 mg|(N=&var_patnum5.)"    style={just=l cellwidth=8% asis=on };

      define c6      / "Placebo|(N=&var_patnum6.)"    style={just=l cellwidth=8% asis=on };

      define c7      / "Total|(N=&var_patnum7.)"    style={just=l cellwidth=8% asis=on };

      compute before PARAMCD;
      line " ";
      endcomp;

   run; 

In resulting RTF file the first page with c1-c4 columns is OK and the second page with c5-c7 columns has only 12 rows and crops everything further that was on the first page.

Am I missing some relevant option or something? Option pagesize made no difference for me.

Thanks a lot for your help.

SAS Super FREQ
Posts: 8,743

Re: In Proc report define page option results in page crop

Hi:

  I don't see PARAMCD in your COLUMN statement. You should be seeing an error message like this in the SAS log:

ERROR: The BREAK variable PARAMCD is not one of the GROUP or

       ORDER variables.

   

  This is the kind of question that really needs to be worked with Tech Support. They can look at ALL your data and ALL your code (including ODS statements) and help you come to a good resolution. Without working code, however, it will be impossible for Tech Support to help you.

cynthia

Frequent Contributor
Posts: 117

Re: In Proc report define page option results in page crop

Hi,

Pls post the complete code including ODS . As Cynthia said there is no where PARAMCD column defined or computed.

Regards,

Vish

Ask a Question
Discussion stats
  • 2 replies
  • 420 views
  • 0 likes
  • 3 in conversation