BookmarkSubscribeRSS Feed
Will_FBB
Calcite | Level 5

Will_FBB_0-1617131720879.png

 

 

 

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;

 

4 REPLIES 4
ballardw
Super User

Which item list?

Between which numbers?

Will_FBB
Calcite | Level 5
Spoiler
Item 1 - 7, subtotal, total on the report output.
ballardw
Super User

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

Will_FBB
Calcite | Level 5

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1079 views
  • 0 likes
  • 2 in conversation