Hi sorry im not entirely sure what you mean by this. Are you saying that I need to run:
title 'Check_CIS DPM';
proc report data=Merged2 split='~';
column SC1 SC2 SC3 SC4 ap_month,(Probability);
define ap_month / Across;
define SC1 / Order;
define SC2 / Order;
define SC3 / Order;
define SC4 / Order;
define Probability / sum;
run;
and if this doesnt work then beforehand i need to run:
PROC SQL;
create table Merged2 as
select SC1 ,SC2 ,SC3, SC4 ,ap_month,sum(Probability) as Probability
from Merged
group by SC1 ,SC2 ,SC3, SC4 ,ap_month;
quit;
and then run again? If so this doesnt seem to work!
... View more