Getting a Note: NOTE: The query requires remerging summary statistics back with the original data. Not sure what the issue is with my program why it is not grouping the data correctly. Here is my code: proc sql; create table trade_class_5_nc_borrow as select date, asset_agreement, product, case when (sourcesystemname = 'Loanet_0250' or inventory = 'T') and product = 'UST' then 'Funding' else 'Non-Cash Borrow' end as new_asset_execution_type, affiliate, o_n_term, maturity_bucket, sum(allocated_funding_value) as sum_allocated_funding_value from class_trade_2 where agreement_type = 'Non-Cash Borrow' group by date, asset_agreement, product, case when (sourcesystemname = 'Loanet_0250' or inventory = 'T') and product = 'UST' then 'Funding' else 'Non-Cash Borrow' end, affiliate, o_n_term, maturity_bucket ; quit; Any help is greatly appreciated! Thanks
... View more