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

dh735 — Wed, 09 Dec 2020 15:46:34 GMT

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!

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

FreelanceReinh — Wed, 09 Dec 2020 16:04:35 GMT

Hello @dh735,

Delete "*," from the inner SELECT statement.

topic NOTE: The query requires remerging summary statistics back with the original data in SAS Enterprise Guide

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

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