Date:         Fri, 14 Jan 2011 15:10:42 -0800
Reply-To:     Sterling Paramore <gnilrets@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sterling Paramore <gnilrets@GMAIL.COM>
Subject:      PROC REPORT - Across variables and cell widths in HTML output
Content-Type: text/plain; charset=ISO-8859-1

Dear SAS-L,

I'm having trouble setting cellwidths with PROC REPORT when I have an across
variable.  For example, the following code produces some ridiculously wide
columns (so I can test that it's working):


proc report data = SASUSER.example;
    where Claim_Incurred_yrmo >= 201001;
    columns Claim_Class_Id Claim_Incurred_yrmo ClaimLine_Allow_Amt ;

    define Claim_Class_Id / group style(header) = [cellwidth=6in];
    define Claim_Incurred_yrmo / group style(column) = [cellwidth=5in];
    define ClaimLine_Allow_Amt / '' analysis sum;

run;

However, in the following report, cellwidth is being ignored:

proc report data = SASUSER.example;
    where Claim_Incurred_yrmo >= 201001;
    columns Claim_Class_Id ClaimLine_Allow_Amt,Claim_Incurred_yrmo;

    define Claim_Class_Id / group style(header) = [cellwidth=6in];
    define Claim_Incurred_yrmo / across style(column) = [cellwidth=5in];
    define ClaimLine_Allow_Amt / '' analysis sum;

run;




I have a suspicion that this problem is because the report is becoming too
wide and it's trying to squeeze the report onto a page that's too small and
thus overriding my explicit cell widths.  Does anyone know how to overcome
this?

Thanks,
Sterling