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;
Which item list?
Between which numbers?
Have you tried moving the ROWS to above where the summaries are calculated? i.e. "before"?
yes, I have. It didn't do anything.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.