In Proc report define page option results in page crop

EdParsadanyan — Sun, 20 Apr 2014 08:28:41 GMT

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.

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

Cynthia_sas — Sun, 20 Apr 2014 16:13:29 GMT

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

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

Vish33 — Tue, 22 Apr 2014 07:46:36 GMT

Hi,

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

Regards,

Vish

topic Re: In Proc report define page option results in page crop in ODS and Base Reporting

In Proc report define page option results in page crop

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

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