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.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 664 views
  • 0 likes
  • 2 in conversation