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!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: