Date:         Thu, 13 Dec 2007 08:36:30 -0800
Reply-To:     "shaunak.adgaonkar@gmail.com" <shaunak.adgaonkar@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "shaunak.adgaonkar@gmail.com" <shaunak.adgaonkar@GMAIL.COM>
Organization: http://groups.google.com
Subject:      How to run report for specific year or date
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi Guys, I have this following proc report.This is an 2007 year end
report but i want to modify it generally so that whenever the date is
changed i can get the new report for specific year


proc report data=one;
by ps_cmp_cde st_cde;
column
ps_acct_cde
BEN_CTRC_NBR
FULL_DSCR
PS_ACTG_DT
DEPT_DESK_CDE
PS_ENT_AMT
;

define ps_acct_cde/'Account';
define ben_ctrc_nbr/order order=data 'Contract';
define full_dscr /display 'Description';
define ps_actg_dt/display 'Date' format=mmddyy10.;
define dept_desk_cde/display 'Dept Desk ';
define ps_ent_amt/analysis order=data sum format=comma12.2'Amount'
style={cellwidth=150};
/*break after ben_ctrc_nbr/summarize skip ol;*/
compute ben_ctrc_nbr ;
     if upcase(_break_) = '_RBREAK_' then
        call define(_col_,'style','style={pretext=" Account
Total"}') ;
     else if upcase(_break_) eq: 'BEN_CTRC_NBR' then do ;
       call define(_col_,'style','style={pretext="Total"}') ;
     end ;
   endcomp ;

break after ben_ctrc_nbr / summarize style={font_style=roman
font_weight=bold};
   rbreak after / summarize summarize style={font_size=11pt
                font_style=roman font_weight=bold};
rbreak after /summarize skip dol ;
quit;


How it can be done ? has anybody done something like this prior ?? any
help would be appreciated...