Proc Computab - move item list to the left

Will_FBB — Tue, 30 Mar 2021 19:15:31 GMT

how do I move item list above to the left instead of sitting in between numbers.

Thanks

proc computab data=rpt_data cspace=1 CWIDTH=4 ;

columns act bud var ytdact ytdbud ytdvar /
/*zero=' '*/;
columns act--var / format=negparen14.0 mtitle="- Month to Date: &mon_char -" ;
columns ytdact--ytdvar / format=negparen14.0 mtitle='- Year To Date -';
columns act ytdact / 'Actual' f=negparen14.0;
columns bud ytdbud / 'Budget' f=negparen14.0;
columns var ytdvar / 'Var' f=negparen14.0;
columns act--ytdvar / '-';
columns ytdact / _titles_;

retain curmo &mon_num; /* current month: February */
rows x1 / ' '
' Item 1';
rows x2 / ' Item 2' ;
rows x3/ ' Item 3' ;
rows x4 / ' Item 4' ;
rows x5/ ' Item 5' ;
rows x6/ ' Item 6' ;
rows x7/ ' Item 7' ;

rows subtotal/ ' Subtotal' ul;

rows total/ ' Total' dul ;

act = type = 'Actual' & month(rpt_dt) = curmo;
bud = type = 'Budget' & month(rpt_dt) = curmo;
ytdact = type = 'Actual' & month(rpt_dt) <= curmo;
ytdbud = type = 'Budget' & month(rpt_dt) <= curmo;

rowcalc:

subtotal=x3+x4+x5+x6+x7;
total=x1+x2+subtotal;

colcalc:
var = act-bud;
ytdvar=ytdact-ytdbud;
run;

Re: Proc Computab - move item list to the left

ballardw — Tue, 30 Mar 2021 15:32:15 GMT

Which item list?

Between which numbers?

Re: Proc Computab - move item list to the left

Will_FBB — Tue, 30 Mar 2021 18:03:19 GMT

Item 1 - 7, subtotal, total on the report output.

Re: Proc Computab - move item list to the left

ballardw — Tue, 30 Mar 2021 20:32:59 GMT

Have you tried moving the ROWS to above where the summaries are calculated? i.e. "before"?

Re: Proc Computab - move item list to the left

Will_FBB — Tue, 30 Mar 2021 21:28:56 GMT

yes, I have. It didn't do anything.

topic Proc Computab - move item list to the left in SAS Enterprise Guide

Proc Computab - move item list to the left

Re: Proc Computab - move item list to the left

Re: Proc Computab - move item list to the left

Re: Proc Computab - move item list to the left

Re: Proc Computab - move item list to the left