NOTE: The query requires remerging summary statistics back with the original data

[dh735]

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!

[FreelanceReinh · Accepted solution]

Hello @dh735,

Delete "*," from the inner SELECT statement.