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: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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