proc report

[azhar7860]

Iam trying to get the report in one page. 

any inputs will be appreciated.

attached: My report(demo1)

               Mock shell(demo)

My Code:

Title1 j=left "Clinical Study Report" j=right "&dat";

Title2 "Table 1 - Summary of demography for the intravenous treatment groups – safety evaluable population";

proc report data=report headline headskip split='*' spacing=1 ;
columns label _0_3_MG_KG_IV _1_0_MG_KG_IV _2_0_MG_KG_IV _2_5_MG_KG_IV TOTAL;

define group2/order descending order=internal noprint; 
define label / display " " width=12 left; *Break gives column total or sub total;
define _0_3_MG_KG_IV / "0.3 mg/kg* IV *&n1" center width=8; 
define _1_0_MG_KG_IV/ "1.0 mg/kg*IV *&n2" center width=8;
define _2_0_MG_KG_IV / "2.0 mg/kg*IV *&n3" center width=8; 
define _2_5_MG_KG_IV / "2.5 mg/kg*IV *&n4" center width=8; 
define TOTAL / "Total*IV *&n5" center width=8;

/*break after group2/page ;*/

compute after /style={Just=L};

/*line @5'';*/
line @1 'SD = Standard deviation';
line @1 'Safety evaluable patient population is defined as patients who received a patient ID and were administered atleast one dose of study medication';
endcomp;
run;
title;
ods rtf close;
ods listing;

Thanks Kindly

[ballardw · Accepted solution]

---

@azhar7860 wrote:

Iam trying to get the report in one page. 

any inputs will be appreciated.

attached: My report(demo1)

               Mock shell(demo)

Not a very clear description of which one is the one you want. From your "in one page" I have to guess that DEMO is the current result and Demo1 is what you want.

Without actual data is hard to test anything and I suspect that part of the issue may be the way that you build your column variable values.

It appears that you may have built character values combining output from some other procedure. So you get values such as "

49.0 ( 11.79)" that have extra spaces that you do not want making your columns wider than that you want which makes it harder to prevent your columns exceeding the width of a page. So one thing is build those strings without

One thing you will need to consider is that some options in Proc Report are not valid for ODS destinations like RTF or PDF. With ODS output you need to use style elements to control such things as column width

[azhar7860]

Thanks for he insight.  I control the style elements using proc template it worked.

Thanks!!