I am having issues to make PROC SQL shows rows with missing values. For example, I have 8 note ranges and some note range has no values when I aggregate it but I want to display all 8 note ranges for each product even though it has no values. Thanks.
proc sql; create table summary as select as_of_date ,Channel ,QRM_Prod ,Note_Range ,sum(before_upb) as before_upb ,sum(after_UPB) as after_UPB ,sum(before_pmt) as before_pmt ,sum(after_pmt) as after_pmt
from msr_act_202102_202107 group by as_of_date ,Channel ,QRM_Prod ,Note_Range order by as_of_date ,Channel ,QRM_Prod ,Note_Range ; quit;
... View more
