Date:         Thu, 3 Oct 1996 18:12:56 -0500
Reply-To:     Thomas Kalfas <kalfast@PPRD.ABBOTT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Thomas Kalfas <kalfast@PPRD.ABBOTT.COM>
Subject:      Re: Column Headers in Proc Repor
Comments: To: Jessica.Gallegos@ncal.kaiperm.org
In-Reply-To:  Jessica.Gallegos@ncal.kaiperm.org "Re: Column Headers in Proc
              Repor" (Oct  3,  3:14pm)

Jessica,
 
Whoops!  I guess I didn't read that the right way.  Here's what I think is a
pretty easy solution to your problem.  The only thing you might want to play
with is the assignment of the TITLE so that it dynamically accounts for the
total length required by your columns.  If you don't mind this, then you can
just set the title to span the entire page.
 
        PROC REPORT DATA=ALL HEADSKIP SPLIT='*';
          COLUMN PCOST CAD CCOST TAD;
 
          DEFINE PCOST / 'PRIOR*COST' ;
          DEFINE CAD   / 'CURRENT*APPROVED*DAYS' ;
          DEFINE CCOST / 'CURRENT*COST' ;
          DEFINE TAD   / 'TOTAL*APPROVED*DAYS' ;
 
          TITLE5 "---------------  &myname.  ACCRUAL  ---------------";
        RUN;
 
Hope this helps.
 
Tom
 
-----------------------------------------------------------------------------
 
On Oct 3,  3:14pm, Jessica.Gallegos@ncal.kaiperm.org wrote:
> Subject: Re: Column Headers in Proc Repor
> Here's the first part of my code:
>
> PROC REPORT DATA=ALL HEADSKIP SPLIT='*';
>   COLUMN CSA MEMB_TP VND_ID
>          ("- &MYNAME. ACCRUAL -" PAD PCOST CAD CCOST TAD TCOST )
>          ("- YEAR-TO-DATE TOTAL -" YAD YCOST);
>
> and here's my output
>
> ---------    AUGUST, 1996 ACCRUAL ----------------
>             CURRENT                       TOTAL
>   PRIOR    APPROVED         CURRENT    APPROVED
>    COST        DAYS            COST        DAYS
>
> and here's what I would like to have:
>
> ---------    AUGUST, 1996 ACCRUAL ----------------
>
>             CURRENT                       TOTAL
>   PRIOR    APPROVED         CURRENT    APPROVED
>    COST        DAYS            COST        DAYS
>
>
> It's that extra line, but I was wondering if there is a simple way to attain
> it.  Thanks!
>
> Jessica Gallegos
> Programmer/Analyst
> Kaiser Permanente
> 1950 Franklin Street, 18th Floor
> Oakland, CA  94612                 E-mail:   pmgjmg@ncal.kaiperm.org
>                                     Phone:   1-510-987-4982
>-- End of excerpt from Jessica.Gallegos@ncal.kaiperm.org
 
 
 
 
--
Thomas Kalfas
System Developer
Abbott Laboratories
 
E-mail: kalfast@pprd.abbott.com
 
Phone:  (847) 938-8101
Fax:    (847) 935-1320