Hello,
I am trying to run the following sql query but keep getting the note "the query requires remerging summary statistics back with the original data". Anybody know how I can go about fixing this?
proc sql noprint;
select max(acc_volume)
into: max_flagged_arrs_CO
from (select *, count(distinct Account_Number) as acc_volume
from arrs_data
where product_type="Credit Card"
group by customer_identifier)
;
quit;
Many Thanks!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.