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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.