BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
dh735
Fluorite | Level 6

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions
1 REPLY 1
FreelanceReinh
Jade | Level 19

Hello @dh735,

 

Delete "*," from the inner SELECT statement.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

Creating Custom Steps in SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1085 views
  • 1 like
  • 2 in conversation